Running import and export procedures from JDBC

You can run 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 a Java program. In this example, the procedure exports the data in the staff table in the default schema to the staff.dat file. A percentage (%) character is used to specify the 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();