Posted: Wed Nov 19, 2008 5:01 am Post subject: Help in JCL
Hi,
I am executing dataquery in a job and printing the output in a PS using following JCL
Code:
//DQRYFTP JOB (TAX,TAX),'DATA QRY',CLASS=P,MSGCLASS=T,
// NOTIFY=&SYSUID
//*
//*******************************************************************
//* JOBS TO RUN DATAQUERY AND SEND THE RESULT TO GIVEN EMAIL ID
//*******************************************************************
//DQBATCH EXEC DQRY,DBMS=DB10H01
//SYSPRINT DD DSN=TTAX.DATAQRY.RESULT,DISP=(NEW,CATLG,DELETE),
// UNIT=DISK,DCB=(RECFM=VB,DSORG=PS,LRECL=3000),
// SPACE=(CYL,(50,10),RLSE)
//SYSIN DD *
SUBMIT PASS DQL 000000000000000000
*/THIS JOB WILL EXECUTE FOLLOWING DATAQUERY /*
FIND LOC-PAY-TOTALS QTD-LOC-SUBJ-WG = 0 QTD-LOC-TXBL-WG = 0
STATE-CODE = '36' YEAR = '2007' QUARTER = '4'
RELATED BY STATE-CODE TO LOCAL-DEF DEP-NACD-SFX = '6691'
RELATED BY STATE-CODE TO FIRST D42-DB517
SORT BY (EE-FILE-NUM)
PRINT
FROM D42-DB517 EE-FILE-NUM
FROM LOC-PAY-TOTALS TSN YEAR QUARTEr
STATE-CODE LOCAL-CODE BRANCH-CODE COMPANY-CODE GSI-RUN-NUM
QTD-LOC-SUBJ-WG QTD-LOC-TXBL-WG QTD-LOC-TAX-WH QTD-HOURS-WORKED
/* DQ INPUT
//*
I am not getting the output in the proper format in the output file. The output file is formatted to record length 133 with block size 133.
Following is the present output:
I want to get the output as exactly seen the dataquery region means no breakup of columns and rows.
I had increased the LRECL to 3000, even then it is taking recl as 133 and formatting the data accordingly. Even I tried printing the output in spool but even in spool data is coming as above.
Please help me in this regard. _________________ Thanks
Madhu Sudhan
Joined: 03 Dec 2002 Posts: 579 Topics: 1 Location: Iowa, USA
Posted: Wed Nov 19, 2008 11:28 am Post subject:
The program that OPENs the SYSPRINT DDname is the final authority on the LRECL used (ignoring the JCL). It must be coded as 133. Change the program. _________________ Regards,
Bill Dennis
Disclaimer: My comments on this foorum are my own and do not represent the opinions or suggestions of any other person or business entity.
Joined: 02 May 2007 Posts: 202 Topics: 0 Location: Viginia, USA
Posted: Wed Nov 19, 2008 11:40 am Post subject:
The program you are using is designed to output 133 character records and that is just what it is doing. It is overrideing the LRECL you are providing and using 133.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
