Executing import/export procedures from JDBC

You can execute import and export procedures from a JDBC program. The following code fragment shows how you might call the SYSCS_UTIL.SYSCS_EXPORT_TABLE procedure from Java. In this example, the procedure exports the staff table data in the default schema to the staff.dat file, using a percentage (%) character to specify a column delimiter.
PreparedStatement ps=conn.prepareStatement("CALL SYSCS_UTIL.SYSCS_EXPORT_TABLE 
(?,?,?,?,?,?)");
ps.setString(1,null);
ps.setString(2,"STAFF");
ps.setString(3,"staff.dat");
ps.setString(4,"%");
ps.setString(5,null);
ps.setString(6,null);
ps.execute();
Related concepts
Importing into tables with identity columns
File format for input and output
Treatment of NULLS
Related reference
Bulk-Import
Bulk-Export
Examples of bulk import and export
CODESET values for import/export