IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

How to get the output from an SQL query onto a PDS?


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
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
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
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
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
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
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
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
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

Senior Member


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

PostPosted: Thu Dec 27, 2007 6:35 pm
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
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Sortjoin and Search for a String and ... DFSORT/ICETOOL 1
No new posts RC query -Time column CA Products 3
No new posts Joinkeys - 5 output files DFSORT/ICETOOL 7
No new posts Dynamically pass table name to a sele... DB2 2
No new posts Query on edit primary command CLIST & REXX 5
Search our Forums:

Back to Top