unload data then extract to file

abraralum · New User Joined: 19 Dec 2010 Posts: 42 Location: Bangalore

I am trying to extract the data from the table to present as a report.

For ex, say my SQL query as below:
select empno,empnm,empdpt from the emptable where empdept in(X to Y).

Here X, Y represents starting from 1 to 1000.

We have some millions of records in table.

Now I am trying to wirte SQL output to spool , but preparing is as a report seems a bit difficult. I want to write to output file.

abraralum · New User Joined: 19 Dec 2010 Posts: 42 Location: Bangalore

Hi,

I managed to to write to a file, now my issue is since data is huge file is not able to hold. Any alternative criteria to hold the data ?

Thanks.

sushanth bobby · Posted: Thu Jan 13, 2011 5:45 pm

Abraralum,

Anuj Dhawan · Posted: Thu Jan 13, 2011 5:56 pm

I'm sorry but I didn't understand - what exactly you are looking for? You already have the query which works for you, so what is that you are looking for?

Anuj Dhawan · Posted: Thu Jan 13, 2011 5:59 pm

abraralum · New User Joined: 19 Dec 2010 Posts: 42 Location: Bangalore

Apologies , I am late to reply to this.

Yes Anuj, it was SB37. what I opted was to put a condition in query for evaluating dept Null value, so that it can be extracted to a file.

Thanks all for your time on this.

AneeshMani · New User Joined: 25 Jan 2008 Posts: 24 Location: india

Hi,

Good Morning...

Try increasing the file size. If your file is large enough to hold your report, you wont be getting the SB37.

Also,

1. Please post your JCL as sushanth has suggested so , we will be in a better position to help you.

2. Make sure to post all possible details like abend codes, your JCL at the beginning so that your queries can be solved ASAP.

Thanks & Regards,
A