db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kathey Marsden (JIRA)" <j...@apache.org>
Subject [jira] Created: (DERBY-2853) Import/Export examples doc corrections
Date Thu, 21 Jun 2007 16:23:26 GMT
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
            Priority: Minor


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.


Mime
View raw message