doc

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
Last revision Both sides next revision
doc [2016/03/23 07:12]
dmtolpeko [Statements]
doc [2016/03/31 15:05]
dmtolpeko [Attributes and Built-in Variables]
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 143: Line 144:
 | [[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 =====