Friday, August 8, 2014

SQR Pre-Defined Variables

#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