CA-L-Serv Commands › SQL Statements › Usage Rules
Usage Rules
- To issue an SQL statement, you must prefix that statement with the LSQL command. You do not need to prefix sub‑queries within a statement with the LSQL command.
- Syntax is diagrammed along the line from left to right. If the entire syntax cannot fit on one line, it splits and continues below the first line. A right arrow at the end of the line indicates that the diagram is continued on the next line.
- Required parameters fall on the line. Optional parameters fall below the line. Required and optional parameters are listed vertically in groups.
- Parameters that can be repeated are indicated by a repeating arrow.
- Variables are printed in italics. When there is a choice of variables, they are separated by a bar ( | ).