Getting Started › DBSQLPR › Sample Report

Sample Report

Following are the first two pages of a DBSQLPR SQL Processor report. For a sample header for this report, see Sample Report Headers.

Command Line Options
 ___________________
 INPUTWIDTH=72
 OPTFILE=OP
 PRTWIDTH=999
 
 
 Option File Options
 ___________________
 AUTHID=SYSADM
 
 INPUT STATEMENT:
 create table testTable (colChar char(18), colInt integer);
 
 ___ SQLCODE=0, SQLSTATE=00000 ___
 
 
 INPUT STATEMENT:
 insert into  testTable values ('colChar row 1', 1);
 
 ___ SQLCODE=0, SQLSTATE=00000, ROWS AFFECTED=1 ___
 
 
 INPUT STATEMENT:
 insert into  testTable values ('colChar row 2', 2);
 
 ___ SQLCODE=0, SQLSTATE=00000, ROWS AFFECTED=1 ___
 
 
 -- Output appears as a table unless "PRTWIDTH=" is exceeded.
 INPUT STATEMENT:
 select colChar, colInt from testTable;
 
 COLCHAR             COLINT
 CHAR(18)            INT
 ___________________ ____________
  colChar row 1                 1
  colChar row 2                 2
 ___ 2 rows returned ___
 
 
 INPUT STATEMENT:
 rollback work;
 
 ___ SQLCODE=0, SQLSTATE=00000 ___

 =================================================
 == DBSQLPR is completing with return code 0000 ==
 ==                                             ==
 ==         Statements Found:   00005           ==
 ==         Statement Errors:   00000           ==
 ==         Statement Warnings: 00000           ==
 =================================================