View previous topic :: View next topic
|
Author |
Message |
xiinus
New User
Joined: 12 Mar 2007 Posts: 13 Location: india
|
|
|
|
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 |
|
|
ksk
Active User
Joined: 08 Jun 2006 Posts: 355 Location: New York
|
|
|
|
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 |
|
|
xiinus
New User
Joined: 12 Mar 2007 Posts: 13 Location: india
|
|
|
|
output dataset will have only mere no. of records . . . I need all the records from the database, which the query can return . . . |
|
Back to top |
|
|
ksk
Active User
Joined: 08 Jun 2006 Posts: 355 Location: New York
|
|
|
|
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 |
|
|
xiinus
New User
Joined: 12 Mar 2007 Posts: 13 Location: india
|
|
|
|
I don't have that option . . . any other way please ???
I appreciate your concern . . . Please help |
|
Back to top |
|
|
xiinus
New User
Joined: 12 Mar 2007 Posts: 13 Location: india
|
|
|
|
I got it . . . Thanks KSK . . . I could find the MAX LINES thing . . .
You rule KSK |
|
Back to top |
|
|
stodolas
Active Member
Joined: 13 Jun 2007 Posts: 632 Location: Wisconsin
|
|
|
|
A more efficient way, if you need all the rows, would be using the DB2 unload utility. |
|
Back to top |
|
|
Phrzby Phil
Senior Member
Joined: 31 Oct 2006 Posts: 1042 Location: Richmond, Virginia
|
|
|
|
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 |
|
|
ksk
Active User
Joined: 08 Jun 2006 Posts: 355 Location: New York
|
|
|
|
Phrzby,
Cool |
|
Back to top |
|
|
|