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();