apache > db
Apache DB Project
 
Font size:      

Examples of bulk import and export

Examples of bulk import and export

All examples in this section are run using the ij utility.

The following example shows how to import data into the staff table in a sample database from the myfile.del file.

CALL SYSCS_UTIL.SYSCS_IMPORT_TABLE (null,'staff','myfile.del',null,null,
null,0);

The following example shows how to import data into the staff table in a sample database from a delimited data filemyfile.del. This example defines the percentage character (%) as the string delimiter, and a semicolon as the column delimiter.

CALL SYSCS_UTIL.SYSCS_IMPORT_TABLE (null,'staff','c:/output/myfile.del',';','%',
null,0);

The following example shows how to export data from the staff table in a sample database to the file myfile.del.

CALL SYSCS_UTIL.SYSCS_EXPORT_TABLE (null,'staff','myfile.del',null,null,null);

The following example shows how to export employee data in department 20 from the staff table in a sample database to the file awards.del.

CALL SYSCS_UTIL.SYSCS_EXPORT_QUERY ('select * from staff where dept=20',
'c:/output/awards.del',null,null,null);

The following example shows how to export data from the staff table to a delimited data file myfile.del with the percentage character (%) as the character delimiter, and a semicolon as the column delimiter from the staff table.

CALL SYSCS_UTIL.SYSCS_EXPORT_TABLE (null,'staff','c:/output/myfile.del',';','%',
null);


Previous Page
Next Page
Table of Contents
Index