Literals

CA Ideal supports the following types of SQL literals in embedded SQL. FOR construct search conditions follow the rules for PDL literals.

Integer constants (for example, +100, 64, ‑15)
Decimal constants (for example, 25.4, ‑56.0, 99.0)
Character strings, delimited by apostrophes (for example, 'literal') or quotation marks (for example, "literal").
To embed an apostrophe (') in a character string, use quotation marks to delimit the character string (for example, "literal's"). To embed quotation marks in a character string, use apostrophes to delimit the string.
In DB2: Hex literals, specified as X followed by a character string (for example, X'FFFF').