A Gentle Introduction to
INSERT, UPDATE and DELETE
How to put records into a table, change them and how to take them out again.
String contains a quote '
If the data contains a single quote it must be escaped.
Possible error messages:
SQL0010N The string constant beginning with "')" does not have an ending string delimiter.
CREATE TABLE t_q (a VARCHAR(8)); INSERT INTO t_q VALUES ('O''Brian'); SELECT * FROM t_q