SQL statements in a CA Ideal PDL program are delimited by EXEC SQL and END‑EXEC. See the EXEC SQL statement.
The following are valid characters to use as delimiters for identifiers, reserved words, and numeric literals: space, comma, left parenthesis (, right parenthesis ), less than <, greater than >, equals =, asterisk *, slash /, not Ø, ampersand &, vertical bar |, and colon :.
The apostrophe or quotation mark delimits alphanumeric literals. Double apostrophes or double quotation marks indicate a literal apostrophe or literal quotation mark.
Identifiers, literals, and reserved words can appear in the right‑most and left‑most columns of the source record.
Double hyphens are comment delimiters in embedded SQL. The colon is reserved for host‑variable names in SQL. You cannot use it as a comment delimiter. See comments.
You cannot break words over the ends of lines.
You can leave lines blank.
For more information about permitted use, see the definitions of names, identifiers, literals, functions, and so on earlier in this chapter.
|
Copyright © 2015 CA Technologies.
All rights reserved.
|
|