CA-L-Serv Commands › SQL Statements › Restrictions on Use

Restrictions on Use

You can issue most LSQL commands from a TSO terminal or a batch job. However, you cannot use cursors from a TSO terminal or a batch job.

You can issue any LSQL command from a CLIST or from a REXX procedure. However, you should keep two things in mind when issuing LSQL commands from a CLIST or from a REXX procedure:

• When using a SELECT statement, values from only one row at a time are returned. If you need to obtain values from multiple rows, you must use a cursor.
• In a REXX procedure, you must enclose an LSQL command in quotation marks if it contains special characters (such as an equal sign).