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

Parent topic: Importing and exporting data
Related concepts
Methods for running the import and export procedures
Bulk import and export requirements and considerations
Bulk import and export of large objects
File format for input and output
How the import and export procedures process NULL values
Related tasks
Importing data using the built-in procedures
Exporting data using the built-in procedures
Related reference
Examples of bulk import and export
CODESET values for import and export procedures