
162 IBM Workplace Forms: Guide to Building and Integrating a Sample Workplace Forms Application
* field name for clob
*/
public static void updateCLOB(String tableName, String id, String id_field,
String clob, String clob_field) {
PreparedStatement stmt;
ResultSet rs = null;
String query = "";
//connect
DB2Connection.connect();
//System.out.println("UPDATE CLOB: " + id);
try {
//creare query
query = "UPDATE " + tableName + " SET (" + clob_field + ") = (?) WHERE " +
id_field + " = '" + id + "'";
stmt = db2con.prepareStatement(query); // Create a Statement object
//assign clob value
stmt.setString(1, clob);
//update
stmt.execute();
db2con.commit();
//close ...