MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Changing the default output line in SPUFI

 
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Database
View previous topic :: View next topic  
Author Message
Balanim
Beginner


Joined: 29 Jan 2004
Posts: 21
Topics: 8
PostPosted: Mon Feb 02, 2004 4:34 am    Post subject: Changing the default output line in SPUFI Reply with quote
Hi

I want to view the full result for my query when i run a SQL in SPUFI. currently i am getting only 250 rows which is the default..please give your inputs.

Bala
Back to top
View user's profile Send private message Yahoo Messenger
kolusu
Site Admin
Site Admin


Joined: 26 Nov 2002
Posts: 12369
Topics: 75
Location: San Jose
PostPosted: Mon Feb 02, 2004 6:23 am    Post subject: Reply with quote
Balanim,

Your profile is set to have a max of 250 rows in spufi. However you can change that. on the spufi main screen you will find the following line

Code:

Specify processing options:                                               
 5 CHANGE DEFAULTS   ===>    YES      (Y/N - Display SPUFI defaults panel?)


Change it to a 'YES' and press ENTER.

Then you will be presented with the following screen.

Code:

Enter the following to control your SPUFI session:                             
 1  SQL TERMINATOR .. ===>    ;     (SQL Statement Terminator)               
 2  ISOLATION LEVEL   ===>    CS       (RR=Repeatable Read, CS=Cursor Stability)
 3  MAX SELECT LINES  ===>    1000     (Maximum number of lines to be 
                                          returned from a SELECT)             
Output data set characteristics:                                               
 4  RECORD LENGTH ... ===>    4092       (LRECL=Logical record length)           
 5  BLOCK SIZE ...... ===>    4096       (Size of one block)                     
 6  RECORD FORMAT ... ===>    VB         (RECFM=F, FB, FBA, V, VB, or VBA)       
 7  DEVICE TYPE ..... ===>    SYSDA      (Must be DASD unit name)                   
Output format characteristics:                                               
 8  MAX NUMERIC FIELD ===>    33       (Maximum width for numeric fields)       
 9  MAX CHAR FIELD .. ===>    80       (Maximum width for character fields)     
10  COLUMN HEADING .. ===> NAMES    (NAMES, LABELS, ANY or BOTH)             


Now change the value for MAX SELECT LINES to the desired value.

Hope this helps...

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Balanim
Beginner


Joined: 29 Jan 2004
Posts: 21
Topics: 8
PostPosted: Wed Feb 04, 2004 12:31 am    Post subject: Reply with quote
Hi Kolusu

Thanx for the answer.. it worked fine..


Bala
Back to top
View user's profile Send private message Yahoo Messenger
Display posts from previous:   
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Database All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group