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
 

 

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: 356
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: 356
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: 964
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: 356
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 Read two inputs and write into output... murali.andaluri DFSORT/ICETOOL 6 Wed Jul 26, 2017 7:35 pm
No new posts How to add header with Date(YYMMDD) i... Rajan Moorthy DFSORT/ICETOOL 2 Thu Jul 06, 2017 11:44 pm
No new posts JES2 doesn't honor the priority of th... Aron Lendvai JCL & VSAM 7 Thu Jun 29, 2017 1:41 pm
No new posts Dynamic output file creation in cobol... smileheal COBOL Programming 7 Thu Jun 15, 2017 10:53 pm
No new posts getting three output files out of JOI... migusd SYNCSORT 7 Mon Jun 05, 2017 11:30 pm


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