Please enable JavaScript to view this site.

If the LIST=SCRIPT parameter is used when invoking the Parser, a listing of the source script file is written to the report. This is very useful for debugging your script files. A sample source script listing as it appears in the Parser report is provided below.

-------------------------

-- Processing DB2TOORA.sqd

-------------------------

SQD00001 JOBNAME DB2TOORA;

SQD00002 COMMIT EVERY 1;

SQD00003 REPORT EVERY 100;

SQD00004

SQD00005 RDBMS ODBC NEVADA sqdata sqdata;

SQD00006

SQD00007 DESCRIPTION SQLDDL /home/sqdata/ORADDL/customer.ddl AS CUST_DESCR;

SQD00008

SQD00009   DATASTORE CUSTOMER

SQD00010      OF RELATIONAL

SQD00011      AS CUSTOMER_IN

SQD00012      DESCRIBED BY CUST_DESCR;

SQD00013

SQD00014   DATASTORE CUSTOMER.del

SQD00015      OF DELIMITED

SQD00016      AS CUSTOMER_OUT

SQD00017      DESCRIBED BY CUST_DESCR;

SQD00018

SQD00019 DECLARE VAR_1 5 ' ';

SQD00020 DECLARE VAR_2 3 '0';

SQD00021

SQD00022 PROCESS INTO CUSTOMER_OUT

SQD00023     SELECT *

SQD00024     FROM CUSTOMER_IN;