Based on Suresh's comment below on this patch, can a committer please commit this?
Also, can we have this patch propogated over to the 10.1 branch? How does that work? Thanks, Jeff --- "Suresh Thalamati (JIRA)" <[email protected]> wrote: > [ > http://issues.apache.org/jira/browse/DERBY-426?page=comments#action_12316168 > ] > > Suresh Thalamati commented on DERBY-426: > ---------------------------------------- > > Changes looks good. > > > documentation need to be modified to reflect the > derby-390 fix(once it is committed) , schem , table > , column names need to be in case-sensitive form. > > > ------------------------------------------------------------------------------------------------------------------------------------------------------- > > > > Key: DERBY-426 > > URL: > http://issues.apache.org/jira/browse/DERBY-426 > > Project: Derby > > Type: Sub-task > > Components: Documentation > > Versions: 10.1.1.0 > > Reporter: Suresh Thalamati > > Attachments: derby426modified.zip > > > > Tools utilities Guide: Using bulk import/export > chapter: > > BulkImport/ Arguments to the import procedure > section: add the following in the end: > > If you created a schema, table or column name as > a non-delimited identifier, you must pass the name > in all upper case. If you created a schema, table or > column name as a delimited identifier, you must pass > the name in the same case as it was created. > > BulkExport/Arguments to the export procedure: add > the following in the end: > > If you have created a schema or table name as a > non-delimited identifier, you must pass the name in > all upper case. If you created a schema or table > name as a delimited identifier, you must pass the > name in the same case as it was created. > > Examples of bulk import and export section: Add > the following two examples to this section: > > The following example shows how to import data > into the Order table (this table was created using > delimited quotes to specify the name becuase the > word 'Order' is a SQL reserved word) table in a > sample database from the myfile.del file. > > CALL SYSCS_UTIL.SYSCS_IMPORT_TABLE > (null,'Order','myfile.del',null,null,null,0); > > The following example shows how to export data > from the Order table (this table was created using > delimited quotes to specify the name becuase the > word 'Order' is a SQL reserved word) in a sample > database from the myfile.del file. > > CALL SYSCS_UTIL.SYSCS_EXPORT_TABLE > (null,'Order','myfile.del',null,null,null); > > Modify the table name 'staff' to all upper case > 'STAFF' > > for all import/export statements except for > EXPORT_QUERY example. > > for example: > > CALL SYSCS_UTIL.SYSCS_IMPORT_TABLE > (null,'staff','myfile.del',null,null, null,0); > > toCALL SYSCS_UTIL.SYSCS_IMPORT_TABLE > (null,'STAFF,'myfile.del',null,null,null,0); > > Importing into tables with identity columns > section : modify table name 'tab1' to 'TAB1' and > all column names > > also to upper case: > > CALL SYSCS_UTIL.SYSCS_IMPORT_DATA (NULL, 'tab1', > 'c1,c3,c4' , null, 'myfile.del',null, null,null,0) > > > to > > CALL SYSCS_UTIL.SYSCS_IMPORT_DATA (NULL, 'TAB1', > 'C1,C3,C4' , null, 'myfile.del',null, null,null,0) > > > CALL SYSCS_UTIL.SYSCS_IMPORT_DATA (NULL, 'tab1', > 'c1,c3,c4' , '1,3,4','empfile.del',null, > null,null,0) > > to > > CALL SYSCS_UTIL.SYSCS_IMPORT_DATA (NULL, 'TAB1', > 'C1,C3,C4' , '1,3,4','empfile.del',null, > null,null,0) > > Executing import/export procedures from JDBC: > modify > > ps.setString(2,"staff"); > > to > > ps.setString(2,"STAFF"); > > CODESET values for import/export section: > > CALL SYSCS_UTIL.SYSCS_EXPORT_TABLE > (NULL,'staff','staff.dat',NULL,NULL,'UTF-8') > > to > > CALL > SYSCS_UTIL.SYSCS_EXPORT_TABLE(NULL,'STAFF','staff.dat',NULL,NULL,'UTF-8') > > and > > CALL > SYSCS_UTIL.SYSCS_IMPORT_TABLE(NULL,'STAFF','staff.dat',NULL,NULL,'UTF-8',0) > > In the REFERENCE Book Please do the following > changes to import/export procedures: > > SYSCS_UTIL.SYSCS_EXPORT_TABLE: > > add the following before the example: > > If you have created a schema or table name as a > non-delimited identifier, you must pass the name in > all upper case. If you created a schema or table > name as a delimited identifier, you must pass the > name in the same case as it was created. > > modify tablename 'staff' to upper case 'STAFF' > > CALL SYSCS_UTIL.SYSCS_EXPORT_TABLE (null, 'staff', > 'myfile.del', null, null, null) > > to > > CALL SYSCS_UTIL.SYSCS_EXPORT_TABLE (null, 'STAFF', > 'myfile.del', null, null, null) > > SYSCS_UTIL.SYSCS_IMPORT_TABLE section: > > add the following before the example: > > If you created a schema or table name as a > non-delimited identifier, you must pass the name in > all upper case. If you created a schema or table > name as a delimited identifier, you must pass the > name in the same case as it was created. > > modify table name 'staff' to 'STAFF' > > CALL SYSCS_UTIL.SYSCS_IMPORT_TABLE(null, 'staff', > 'c:/output/myfile.del', ';', '%', null,0); > > to > > CALL SYSCS_UTIL.SYSCS_IMPORT_TABLE(null, 'STAFF', > 'c:/output/myfile.del', ';', '%', null,0); > > SYSCS_UTIL.SYSCS_IMPORT_DATA section: > > If you created a schema, table or column name as > a non-delimited identifier, you must pass the name > in all upper case. If you created a schema, table or > column name as a delimited identifier, you must pass > the name in the same case as it was created > > modify > > CALL SYSCS_UTIL.SYSCS_IMPORT_DATA(NULL, 'staff', > null, '1,3,4', 'data.del', null, null, null,0) > > to > > CALL SYSCS_UTIL.SYSCS_IMPORT_DATA(NULL, 'STAFF', > null, '1,3,4', 'data.del', null, null, null,0) > > -- > This message is automatically generated by JIRA. > - > If you think it was sent incorrectly contact one of > the administrators: > > http://issues.apache.org/jira/secure/Administrators.jspa > - > For more information on JIRA, see: > http://www.atlassian.com/software/jira > >
