Derby
  1. Derby
  2. DERBY-2853

Import/Export examples doc corrections

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Minor Minor
    • Resolution: Fixed
    • Affects Version/s: 10.3.1.4
    • Fix Version/s: 10.3.1.4, 10.4.1.3
    • Component/s: Documentation
    • Labels:
      None

      Description

      The following corrections are needed in the import/export examples.

      http://db.apache.org/derby/docs/dev/tools/rtoolsimport91458.html
      1)
      CALL SYSCS_UTIL.SYSCS_EXPORT_TABLE_LOBS_TO_EXTFILE('APP','STAFF'
      'c:\data\staff.del',',','"','UTF-8', 'c:\data\pictures.dat');

      Should be:
      CALL SYSCS_UTIL.SYSCS_EXPORT_TABLE_LOBS_TO_EXTFILE(null,'STAFF',
      'c:\data\staff.del',',','"','UTF-8', 'c:\data\pictures.dat');

      2)
      CALL SYSCS_UTIL.SYSCS_IMPORT_TABLE_LOBS_FROM_EXTFILE(
      'APP','STAFF','c:\data\staff.del',',','"','UTF-8',0);

      should be:
      CALL SYSCS_UTIL.SYSCS_IMPORT_TABLE_LOBS_FROM_EXTFILE(
      null,'STAFF','c:\data\staff.del',',','"','UTF-8',0);

      http://db.apache.org/derby/docs/dev/tools/ctoolsimportjdbc.html

      PreparedStatement ps=conn.prepareStatement(
      "CALL SYSCS_UTIL.SYSCS_EXPORT_TABLE ?,?,?,?,?,?)");

      should be:
      PreparedStatement ps=conn.prepareStatement(
      "CALL SYSCS_UTIL.SYSCS_EXPORT_TABLE (?,?,?,?,?,?)");

      http://db.apache.org/derby/docs/dev/tools/ttoolsimporting.html
      The format of the table looks a little odd.

      1. derby2853_2.diff
        12 kB
        Laura Stewart
      2. rtoolsimport91458.html
        11 kB
        Laura Stewart
      3. ctoolsimportjdbc.html
        6 kB
        Laura Stewart
      4. derby2853.diff
        10 kB
        Laura Stewart

        Issue Links

          Activity

          Hide
          Laura Stewart added a comment -

          Attaching updated patch

          Show
          Laura Stewart added a comment - Attaching updated patch
          Hide
          Laura Stewart added a comment -

          Attaching updated html files for this patch.

          Kathey - I tried to fix the appearance of the table but there must be something
          wrong with the style sheet... I'll mention this on derbydev to see if we can resolve it.

          Show
          Laura Stewart added a comment - Attaching updated html files for this patch. Kathey - I tried to fix the appearance of the table but there must be something wrong with the style sheet... I'll mention this on derbydev to see if we can resolve it.
          Hide
          Laura Stewart added a comment -

          Committed revision 553553.

          Show
          Laura Stewart added a comment - Committed revision 553553.
          Hide
          Laura Stewart added a comment -

          Committed to 10.3 branch with
          Committed revision 553554.

          Show
          Laura Stewart added a comment - Committed to 10.3 branch with Committed revision 553554.

            People

            • Assignee:
              Laura Stewart
              Reporter:
              Kathey Marsden
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development