rec.update(conn);
// Now extend the size of the field from 20 to 40 characters
System.out.println("Extending size of column FOO to 40 characters:");
C_FOO.setSize(40);
script.clear();
db.getDriver().getDDLScript(DBCmdType.ALTER, C_FOO, script);
script.run(db.getDriver(), conn, false);
// Now set a longer value for the record
System.out.println("Changing the value for the FOO field for the above employee to a longer string:");