You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Laura Stewart (JIRA)" <ji...@apache.org> on 2007/07/05 18:27:04 UTC
[jira] Resolved: (DERBY-2853) Import/Export examples doc
corrections
[ https://issues.apache.org/jira/browse/DERBY-2853?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Laura Stewart resolved DERBY-2853.
----------------------------------
Resolution: Fixed
Derby Info: (was: [Patch Available])
Committed revision 553553.
> Import/Export examples doc corrections
> --------------------------------------
>
> Key: DERBY-2853
> URL: https://issues.apache.org/jira/browse/DERBY-2853
> Project: Derby
> Issue Type: Bug
> Components: Documentation
> Affects Versions: 10.3.0.0
> Reporter: Kathey Marsden
> Assignee: Laura Stewart
> Priority: Minor
> Attachments: ctoolsimportjdbc.html, derby2853.diff, derby2853_2.diff, rtoolsimport91458.html
>
>
> 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.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.