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 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 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:
  • 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 that the SQL server named is set to the returned value.
  • Error messages are sent to the terminal.
• If the command is issued from a REXX procedure:
  • 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 that the SQL server named is set to the returned value.
  • Error messages are sent to the terminal.

For more information about the information that an LSQL command returns, see the CA-L-Server administrating topics.