String Literals
Use single quotes to delimit Embedded SQL string literals. To embed a single quote in a string literal, use two single quotes, for example:
exec sql update employee
1 set comments ='Doesn''t seem to relax'
2 where eno = :numvar
You can continue string literals over multiple lines. Following Fortran rules, if the continued line ends without a closing quotation mark, the continuation line must follow the rules for continuation markers. The first character after the continuation marker is considered part of the string literal. For example:
exec sql update employee
1 set comments = 'Completed all projects on time.
2 Recommended for promotion.'
3 where ename = 'Jones'
Do not place comment lines between string literal continuation lines.