Storing the output of sql in a dataset

navneet.dewangan · New User Joined: 09 Oct 2005 Posts: 22 Location: INDIA

Hi,

I have fired a sql using the job, however i am not able to store the result into dataset using the job.

I am trying the below, however the job abends with CODE=4039

//SYSTSPRT DD SYSOUT=Q
//SYSABOUT DD SYSOUT=Q
//SYSPRINT DD DSN=DBA.CNTL(SQLREP),DISP=SHR
//SYSOUT DD SYSOUT=Q
//SYSTSIN DD *

Please help, how could i identify the recordlengen and blk size of the dataset to store SQL results

Bharath Bhat · Posted: Mon Aug 03, 2009 5:14 pm

You can specify LRECL and BLKSIZE = 0 (if its for testing purposes).

The LRECL would depend on your result set. So if you could calculate the total length of your result set, you'll get the record length.

Bharath Bhat · Posted: Mon Aug 03, 2009 5:15 pm

By the way, can you post your error messages here. Please use the code tag.

Craq Giegerich · Posted: Mon Aug 03, 2009 5:44 pm

By the way you could tell us what program you are using and show us the proc that you are using!

Marso · Posted: Mon Aug 03, 2009 5:46 pm

CNTL files are usualy defined with RECFM=FB and LRECL=80
print files are mostly defined with RECFM=FBA and LRECL=133

These are standard conventions. Please respect them.

Do not place cobol programs or COPY members in the CNTL library,
do not put JCLs in the COBOL library, do not put listings in the CNTL, and so on.

Have a different library for each use.

navneet.dewangan · New User Joined: 09 Oct 2005 Posts: 22 Location: INDIA

Many thanks for reminding the rules. Please pass me the reference document if you have any for this consideration.

Thanks a lot

dick scherrer · Posted: Mon Aug 03, 2009 8:38 pm

Hello,