CA-L-Serv Commands › SQL Statements › Command Output

Command Output

The SQL server returns several elements after executing an LSQL command. The type of information you receive depends on where you issue the command:

• If the command is issued from a TSO terminal, the following occurs:
  • The returned values, any error messages, or both are sent to the terminal.
  • No return codes are set.
• If the command is issued from a batch job, the following occurs:
  • The job step return code is set with the SQL server return code.
  • The output from the command is sent to SYSPRINT.
• If the command is issued from a CLIST, the following occurs:
  • Return codes are set in the &LASTCC variable.
  • If the return code is 0, 4, or 8, the SQL server also assigns a value to the SQLCODE variable.
  • The specified host variables are set to the returned values; otherwise, a variable named by the SQL server is set to the returned value.
  • Error messages are sent to the terminal.
• If the command is issued from a REXX procedure, the following occurs:
  • Return codes are set in the RC variable in REXX.
  • If the return code is 0, 4, or 8, the SQL server also assigns a value to the SQLCODE variable.
  • The specified host variables are set to the returned values; otherwise, a variable named by the SQL server is set to the returned value.
  • Error messages are sent to the terminal.

For more information on the information returned by an LSQL command, see the chapter "CA‑L‑Serv" in the Administration Guide.