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.diff
        10 kB
        Laura Stewart
      2. ctoolsimportjdbc.html
        6 kB
        Laura Stewart
      3. rtoolsimport91458.html
        11 kB
        Laura Stewart
      4. derby2853_2.diff
        12 kB
        Laura Stewart

        Issue Links

          Activity

          Kathey Marsden created issue -
          Kathey Marsden made changes -
          Field Original Value New Value
          Link This issue relates to DERBY-2860 [ DERBY-2860 ]
          Laura Stewart made changes -
          Assignee Laura Stewart [ scotsmatrix ]
          Hide
          Laura Stewart added a comment -

          Attaching updated patch

          Show
          Laura Stewart added a comment - Attaching updated patch
          Laura Stewart made changes -
          Attachment derby2853.diff [ 12361059 ]
          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.
          Laura Stewart made changes -
          Attachment ctoolsimportjdbc.html [ 12361062 ]
          Attachment rtoolsimport91458.html [ 12361063 ]
          Laura Stewart made changes -
          Derby Info [Patch Available]
          Laura Stewart made changes -
          Attachment derby2853_2.diff [ 12361203 ]
          Hide
          Laura Stewart added a comment -

          Committed revision 553553.

          Show
          Laura Stewart added a comment - Committed revision 553553.
          Laura Stewart made changes -
          Status Open [ 1 ] Resolved [ 5 ]
          Derby Info [Patch Available]
          Resolution Fixed [ 1 ]
          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.
          Kathey Marsden made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          Myrna van Lunteren made changes -
          Fix Version/s 10.4.1.3 [ 12313111 ]
          Fix Version/s 10.3.1.4 [ 12312590 ]
          Gavin made changes -
          Workflow jira [ 12406788 ] Default workflow, editable Closed status [ 12797378 ]
          Transition Time In Source Status Execution Times Last Executer Last Execution Date
          Open Open Resolved Resolved
          14d 2m 1 Laura Stewart 05/Jul/07 17:25
          Resolved Resolved Closed Closed
          43d 6h 8m 1 Kathey Marsden 17/Aug/07 23:34

            People

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

              Dates

              • Created:
                Updated:
                Resolved:

                Development