Determine when to use stored procedures vs. SQL in the code Your email has been sent Tony Patton discusses the merits of stored procedures versus placing SQL directly in the code. Find out which ...

See SQL Procedure Pass-Through Facility Return Codes for more information ... This transaction is affected by any SQL COMMITs or ROLLBACKs that are performed within the connection while executing the ...

The value is returned through the macro variable SQLRC (a short form for SQL return code). For example, if a SELECT statement is valid, the macro variable SQLRC returns a value of 0. See Using Macro ...