#current-column | The current column on the page. |
#current-line | Refers to the physical line number on the page. |
#end-file | Set to one (1) if end of file occurs on READ, otherwise zero (0). |
#page-count | The current page number. |
#return-status | Value to be returned to the operating system when SQR exits. |
#sql-count | The count of rows affected by a DML statement (insert, update and delete). |
$sql-error | The text message from the database explaining the most recent error. |
#sql-status | The status value from the database after each query is compiled or executed. |
$sqr-database | The database type for which SQR Workbench was compiled. Valid values are: Allbase* DB2 Informix Ingres Oracle RDB* SQLBase SYBASE |
{sqr-database} | see $sqr-database above |
#sqr-pid | The process ID of the current SQR process. Unique for each run of SQR. |
$sqr-platform | The hardware/operating system type for which SQR was compiled. Valid values are: DOS* MVS WINDOWS UNIX VM VMS |
{sqr-platform} | see $sqr-platform above |
$sqr-program | The name of the SQR program file. |
$sqr-report | The name of the report output file. Reflects the actual name to be used (-F flag or NEW-REPORT command). |
$sqr-ver | The text string shown with the -ID flag. |
$username | The database username specified on the command line. |
Source : http://www.ontko.com/sqr/sqrcard.html
No comments:
Post a Comment