Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

unload data then extract to file

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
abraralum

New User


Joined: 19 Dec 2010
Posts: 42
Location: Bangalore

PostPosted: Thu Jan 13, 2011 3:48 pm    Post subject: unload data then extract to file
Reply with quote

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.
Back to top
View user's profile Send private message

abraralum

New User


Joined: 19 Dec 2010
Posts: 42
Location: Bangalore

PostPosted: Thu Jan 13, 2011 4:29 pm    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Thu Jan 13, 2011 5:45 pm    Post subject:
Reply with quote

Abraralum,

Quote:
file is not able to hold.

You have be more elaborate than that.

Show us your jcl and error you have got, so it will be easier for others to help you.

Thanks,
Sushanth
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Thu Jan 13, 2011 5:56 pm    Post subject:
Reply with quote

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?
Quote:
but preparing is as a report seems a bit difficult
so do you need some help here?
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Thu Jan 13, 2011 5:59 pm    Post subject:
Reply with quote

Quote:
now my issue is since data is huge file is not able to hold
oh..does it flow out of the system then or you just get an SB37 or similar abend!? icon_smile.gif
Back to top
View user's profile Send private message
abraralum

New User


Joined: 19 Dec 2010
Posts: 42
Location: Bangalore

PostPosted: Sun Jan 16, 2011 1:26 pm    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
AneeshMani

New User


Joined: 25 Jan 2008
Posts: 24
Location: india

PostPosted: Mon Jan 17, 2011 7:00 am    Post subject: Reply to: unload data then extract to file
Reply with quote

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
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Match two files using multiple keys a... santoshks1987 SYNCSORT 10 Fri Aug 18, 2017 10:50 am
No new posts Multiple VSAM files single output fil... Mohan Kothakota DFSORT/ICETOOL 11 Wed Aug 09, 2017 7:57 pm
This topic is locked: you cannot edit posts or make replies. rexx code to create a ps file Bharath Vikraman CLIST & REXX 4 Mon Aug 07, 2017 10:30 am
No new posts Unable to copy data from spool in a d... srikant314 JCL & VSAM 8 Fri Jul 28, 2017 9:10 pm
No new posts Split file based on comparsion to 2 f... Div Grad DFSORT/ICETOOL 3 Thu Jul 27, 2017 9:16 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us