Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
How to get the output from an SQL query onto a PDS?

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

New User


Joined: 12 Mar 2007
Posts: 13
Location: india

PostPosted: Thu Dec 27, 2007 10:00 am    Post subject: How to get the output from an SQL query onto a PDS?
Reply with quote

Please Help !!!

I need to run a query in SPUFI and get the output on a file in PDS, Please let me know how to code this?

PLEASE HELP !!!
Back to top
View user's profile Send private message

ksk

Active User


Joined: 08 Jun 2006
Posts: 355
Location: New York

PostPosted: Thu Dec 27, 2007 10:07 am    Post subject:
Reply with quote

Hi,

Go to SPUFI option, provide your input datset in which you are going to write query and provide output dataset in the respective field.

NOTE: Input datset must be cataloged but Output datset no need to be catlogued.

Regards,
KSK
Back to top
View user's profile Send private message
xiinus

New User


Joined: 12 Mar 2007
Posts: 13
Location: india

PostPosted: Thu Dec 27, 2007 10:10 am    Post subject:
Reply with quote

output dataset will have only mere no. of records . . . I need all the records from the database, which the query can return . . . icon_smile.gif
Back to top
View user's profile Send private message
ksk

Active User


Joined: 08 Jun 2006
Posts: 355
Location: New York

PostPosted: Thu Dec 27, 2007 10:17 am    Post subject:
Reply with quote

Change your settings. You could see an option "MAX SELECT LINES". Make it as much as you want. Maximum is 99999999.

KSK
Back to top
View user's profile Send private message
xiinus

New User


Joined: 12 Mar 2007
Posts: 13
Location: india

PostPosted: Thu Dec 27, 2007 10:23 am    Post subject:
Reply with quote

icon_sad.gif I don't have that option . . . any other way please ???

I appreciate your concern . . . Please help icon_smile.gif
Back to top
View user's profile Send private message
xiinus

New User


Joined: 12 Mar 2007
Posts: 13
Location: india

PostPosted: Thu Dec 27, 2007 10:24 am    Post subject:
Reply with quote

I got it . . . Thanks KSK . . . I could find the MAX LINES thing . . .

You rule KSK icon_smile.gif
Back to top
View user's profile Send private message
stodolas

Active Member


Joined: 13 Jun 2007
Posts: 632
Location: Wisconsin

PostPosted: Thu Dec 27, 2007 6:20 pm    Post subject:
Reply with quote

A more efficient way, if you need all the rows, would be using the DB2 unload utility.
Back to top
View user's profile Send private message
Phrzby Phil

Active Member


Joined: 31 Oct 2006
Posts: 968
Location: Richmond, Virginia

PostPosted: Thu Dec 27, 2007 6:35 pm    Post subject:
Reply with quote

KSK rules because he looks around to see what's on his screens, then probably checks the F1 help sometimes, then experiments.
Back to top
View user's profile Send private message
ksk

Active User


Joined: 08 Jun 2006
Posts: 355
Location: New York

PostPosted: Fri Dec 28, 2007 2:53 pm    Post subject:
Reply with quote

Phrzby,

Cool icon_eek.gif
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 reg query on DYNALLOC feature raghuraman123 SYNCSORT 12 Wed Jan 10, 2018 2:42 pm
No new posts query to fetch record which has only ... maxsubrat DB2 12 Mon Dec 11, 2017 5:03 pm
No new posts How to query MAXGENS of an existing P... Chuchulo Hatyzak JCL & VSAM 4 Wed Nov 22, 2017 10:23 pm
No new posts Native SQL Query kishpra DB2 1 Wed Nov 22, 2017 8:38 pm
No new posts VBS and VB, COBOL syntax is the same ... natt.sut COBOL Programming 3 Sun Nov 12, 2017 6:36 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us