[DERBY-2853] Import/Export examples doc corrections

• 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
• Assignee: Laura Stewart
• Reporter: Katherine Marsden
• Created: 21/Jun/07 20:22
• Updated: 14/Apr/09 05:56
• Resolved: 05/Jul/07 20:25

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.

Issue Links

• relates to: DERBY-2860 Documentation problems for IMPORT/EXPORT LOBs feature