Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-2853

Import/Export examples doc corrections

    Details

    • Type: Bug
    • Status: Closed
    • Priority: 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.

        Attachments

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

          Issue Links

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: