doc
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
doc [2016/03/23 07:12] dmtolpeko [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 | | ||
| Line 143: | Line 145: | ||
| | [[upper|UPPER]] || Convert a string to upper case | | | [[upper|UPPER]] || Convert a string to upper case | | ||
| | [[user|USER]] || Get the current user name | | | [[user|USER]] || Get the current user name | | ||
| + | |||
| + | ===== BTEQ Statements ===== | ||
| + | |||
| + | HPL/SQL BTEQ statements: | ||
| + | |||
| + | | [[if|.IF]] | IF statement | | ||
| + | | [[quit|.QUIT]] | Terminate execution and quit | | ||
| + | |||
| ===== Commands ===== | ===== Commands ===== | ||
Page Tools
