[jira] Updated: (DERBY-2853) Import/Export examples doc corrections

["Laura Stewart (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/DERBY-2853?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Laura Stewart updated DERBY-2853:
---------------------------------

    Attachment: derby2853.diff

Attaching updated patch

> 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: derby2853.diff
>
>
> 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.