Using ODBC to update tables

By default all tables are read-only in the catalog and the only SQL verb that can be used is ODBC is SELECT. With most databases this is the sensible option as access by PC programs using ODBC could compromise referential integrity. However it is also possible to use the full SQL DML grammar inclusing UPDATE and INSERT provided the table is flagged as writable in the catalog and provided the ODBC server program kiodbc is running with the -m command line switch.