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

          Gavin made changes -
          Workflow jira [ 12406788 ] Default workflow, editable Closed status [ 12797378 ]
          Myrna van Lunteren made changes -
          Fix Version/s 10.4.1.3 [ 12313111 ]
          Fix Version/s 10.3.1.4 [ 12312590 ]
          Kathey Marsden made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          Laura Stewart made changes -
          Status Open [ 1 ] Resolved [ 5 ]
          Derby Info [Patch Available]
          Resolution Fixed [ 1 ]
          Laura Stewart made changes -
          Attachment derby2853_2.diff [ 12361203 ]
          Laura Stewart made changes -
          Derby Info [Patch Available]
          Laura Stewart made changes -
          Attachment ctoolsimportjdbc.html [ 12361062 ]
          Attachment rtoolsimport91458.html [ 12361063 ]
          Laura Stewart made changes -
          Attachment derby2853.diff [ 12361059 ]
          Laura Stewart made changes -
          Assignee Laura Stewart [ scotsmatrix ]
          Kathey Marsden made changes -
          Field Original Value New Value
          Link This issue relates to DERBY-2860 [ DERBY-2860 ]
          Kathey Marsden created issue -

            People

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

              Dates

              • Created:
                Updated:
                Resolved:

                Development