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

Import/Export examples doc corrections

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • 10.3.1.4
    • 10.3.1.4, 10.4.1.3
    • Documentation
    • 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

              scotsmatrix Laura Stewart
              kmarsden Katherine Marsden
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: