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

Restrictions on Use

You can issue most of the 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, keep in mind two things when issuing the 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. To obtain values from multiple rows, use a cursor.
• In a REXX procedure, enclose an LSQL command in quotation marks if it contains special characters (such as an equal sign).