The Formator has been designed to format SQR programs and is implemented by the SQR program VGLFRMT. It is controlled by commands provided in the input stream and has been designed run in both the MVS and Windows environment. The Schedulor shells PSSQRSQL and PSSQRSQT show using the Formator in JCL.

Commands

Command

Description

DBGSQLT=x

Prefix the calls to the SQL Timor tool procedure VGLSQLT with the #DEBUGx command where x is a single alphabetic character or numeric digit.                                

DBGSQRT=x

Prefix the calls to the SQR Tracor tool procedure VGLSQRT with the #DEBUGx command where x is a single alphabetic character or numeric digit.

EXPAND=<YES | NO>

Expand the #INCLUDE commands.

Default value is YES

SQRIN=file

SQR program input file. This parameter will be used by the SQR OPEN statement and must conform to the operating system convention. For MVS, the format is

or         DD:SQRIN(TESTPROG) DD name for a PDS

or         DD:SQRIN DD name for a member of a PDS

or         DD:SQRIN DD name for a sequential dataset

or         DSN:VGL.TEST.SQR(TESTPROG) PDS

or         DSN:VGL.TESTPROG.SQR sequential dataset

For the Windows client the format is

            c:\sqr\testprog.sqr 

SQRINC=path

SQR include file. This parameter will be used by the SQR OPEN statement to read the included SQCs.

For MVS, it should be a DD name like DD:SQRINC pointing to all the include files. If all the include files are in one PDS, it could also be the dataset name as in DSN:VGL.TEST.SQC.

For the Windows client, this is the first directory check and the format is c:\vgltools\

SQRINC2=path

Second level include file path. Not used by MVS.

For the Windows client, this is the second directory check and the format is c:\sqr\user\

SQRINC3=path

Third level include file path. Not used by MVS.

For the Windows client, this is the third directory check and the format is c:\sqr\

SQRINC4=path

Fourth level include file path. Not used by MVS.

For the Windows client, this is the fourth directory check and the format is x:\sqr\

SQROUT=file

SQR program output file. This parameter will be used by the SQR OPEN statement and must conform to the operating system convention. For MVS, the format is

or         DD:SQROUT(TESTPROG) DD name for a PDS

or         DD:SQROUT DD name for a member of a PDS

or         DD:SQROUT DD name for a sequential dataset

or         DSN:VGL.TEST.SQROUT(TESTPROG) PDS

or         DSN:VGL.TESTPROG.SQROUT sequential dataset

For the Windows client the format is

            c:\sqr\modified\testprog.sqr 

STRIP=<YES | NO>

Right justify the SQR code and remove all comments and blank lines.

Default value is NO

VGLSQLT=<YES | NO>

Insert calls to the SQL Timor tool. The VGLSQLT sqc must be in a library or directory referenced by a SQRINCx parameter.

Default value is YES

 

VGLSQLTL=<YES | NO>

Use the “Lite” version SQL Timor tool. The VGLSQLT sqc must be in a library or directory referenced by a SQRINCx parameter.

Default value is NO

 

VGLSQRT=<YES | NO>

Insert calls to the SQR Tracor tool. The VGLSQRT sqc must be in a library or directory referenced by a SQRINCx parameter.

Default value is NO