Details
-
Bug
-
Status: Closed
-
Minor
-
Resolution: Fixed
-
10.3.1.4
-
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
Attachments
Issue Links
- relates to
-
DERBY-2860 Documentation problems for IMPORT/EXPORT LOBs feature
- Closed