This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
doc [2016/03/31 12:27] dmtolpeko [BTEQ Statements] |
doc [2017/08/04 18:07] dmtolpeko [Statements] |
||
---|---|---|---|
Line 39: | Line 39: | ||
| [[activity_count|ACTIVITY_COUNT]] | Number of rows affected by last SQL statement | | | [[activity_count|ACTIVITY_COUNT]] | Number of rows affected by last SQL statement | | ||
+ | | [[errorcode|ERRORCODE]] | Return code of the last SQL statement | | ||
| [[hostcode|HOSTCODE]] | Return code of the last OS command | | | [[hostcode|HOSTCODE]] | Return code of the last OS command | | ||
| [[sqlcode|SQLCODE]] | Return code of the last SQL statement | | | [[sqlcode|SQLCODE]] | Return code of the last SQL statement | | ||
Line 93: | Line 94: | ||
| [[select-into|SELECT INTO]] ||| Assign values from a query | | | [[select-into|SELECT INTO]] ||| Assign values from a query | | ||
| [[signal|SIGNAL]] ||| Raise a condition or exception | | | [[signal|SIGNAL]] ||| Raise a condition or exception | | ||
+ | | [[summary|SUMMARY]] ||| Summary stats for a table or result set | | ||
| [[assign|SET]] ||| Assign a value to a variable | | | [[assign|SET]] ||| Assign a value to a variable | | ||
| [[set-session|SET Session Option]] ||| Set a session option | | | [[set-session|SET Session Option]] ||| Set a session option | |