Purpose
APOSTSQL specifies that for embedded SQL statements, the string delimiter is the apostrophe (') and that the SQL escape (name) delimiter is the quotation mark (").
QUOTESQL specifies that in embedded SQL statements, the string delimiter is the quotation mark (") and that the SQL escape (name) delimiter is the apostrophe (').
Usage Notes
APOSTSQL and QUOTESQL are mutually exclusive.
Do not explicitly specify QUOTESQL in any language except COBOL.
These options do not affect string delimiters in host language statements.
Specification | Language |
---|---|
QUOTESQL | This is the default for COBOL, if QUOTE is specified. |
APOSTSQL | This is the default for COBOL, if APOST is specified or defaulted. |
APOSTSQL | This is the default for PL/I and cannot be changed. |
APOSTSQL | This is the default for C and cannot be changed. |