IBM Mainframe Forum

Mainframe Technical Support Forums

Skip to content


MAXIMUM OUTPUT LINES in spufi



IBM's flagship relational database management system
Post a reply

MAXIMUM OUTPUT LINES in spufi

Postby surime72 » Mon Mar 11, 2013 3:45 pm

Hi

While i was trying to run sql query in spufi it showing error as MAXIMUM OUTPUT LINES FOR SELECT STATEMENT REACHED (250), PROCESSING FOR PROCESSING FOR CURRENT SELECT STATEMENT TERMINATED NUMBER OF ROWS DISPLAYED IS 250
surime72
 
Posts: 107
Joined: Sun Oct 23, 2011 1:45 pm
Has thanked: 0 time
Been thanked: 0 time
Top

Re: spufi

Postby prino » Mon Mar 11, 2013 3:54 pm

That's not an error.
Robert AH Prins
robert.ah.prins @ the.17+Gb.Google thingy
User avatar
prino
 
Posts: 640
Joined: Wed Mar 11, 2009 12:22 am
Location: Vilnius, Lithuania
Has thanked: 3 times
Been thanked: 29 times
Top

Re: spufi

Postby c62ap90 » Mon Mar 11, 2013 6:35 pm

You can change the Max Select Lines from your Current SPUFI Default screen.

CURRENT SPUFI DEFAULTS
3 MAX SELECT LINES ===> 250
c62ap90
 
Posts: 125
Joined: Thu Oct 11, 2012 10:24 pm
Has thanked: 1 time
Been thanked: 7 times
Top

Re: MAXIMUM OUTPUT LINES in spufi

Postby surime72 » Tue Mar 12, 2013 1:12 pm

Thanks it's working fine...
surime72
 
Posts: 107
Joined: Sun Oct 23, 2011 1:45 pm
Has thanked: 0 time
Been thanked: 0 time
Top

Re: MAXIMUM OUTPUT LINES in spufi

Postby c62ap90 » Tue Mar 12, 2013 4:14 pm

surime72 wrote:Thanks it's working fine...

You are welcome.
c62ap90
 
Posts: 125
Joined: Thu Oct 11, 2012 10:24 pm
Has thanked: 1 time
Been thanked: 7 times
Top
Post a reply

Return to DB2

 


  • Related topics
    Replies
    Views
    Last post
Forum Rules|FAQ|Subscriptions|Bookmarks