%META:TOPICPARENT{name="ErrorMessagesM"}%

==Error Messages (M)==

[[UDAErrorMessages|A]] [[ErrorMessagesB|B]] [[ErrorMessagesC|C]] [[ErrorMessagesD|D]] [[ErrorMessagesE|E]] [[ErrorMessagesF|F]] [[ErrorMessagesG|G]] [[ErrorMessagesH|H]] [[ErrorMessagesI|I]] [[ErrorMessagesJ|J]] [[ErrorMessagesK|K]] [[ErrorMessagesL|L]] [[ErrorMessagesM|M]] [[ErrorMessagesN|N]] [[ErrorMessagesO|O]] [[ErrorMessagesP|P]] [[ErrorMessagesQ|Q]] [[ErrorMessagesR|R]] [[ErrorMessagesS|S]] [[ErrorMessagesT|T]] [[ErrorMessagesU|U]] [[ErrorMessagesV|V]] [[ErrorMessagesW|W]] [[ErrorMessagesX|X]] [[ErrorMessagesY|Y]] [[ErrorMessagesZ|Z]] [[ErrorMessagesSymbols|#]]
    
===Maximum of 100 rows returned for all SELECT statements===


If your SELECT statements return only 100 rows, when more than 100 rows are expected, take the following action:
    
       
* Open the active <nop>OpenLink Request Broker Rulebook, oplrqb.ini, in a text editor. This file is typically found in the /bin/ sub-directory of your <nop>OpenLink server components installation.
    
       
* Locate the [generic_xxx] section which is active for this connection. For example:
    
{{{
                 
[generic_inf72]
Description = Default settings for Informix 7.2 agent
Program     = inf72_sv
Environment = INFORMIX72
OpsysLogin  = Yes
ReUse       = never
;CommandLine = +norowsetlimit
}}}
     
* Make sure there is no semicolon (;) in front of <nop>CommandLine (as this makes the line a comment, and the value then has no effect).
    
* If not present, add +norowsetlimit to the <nop>CommandLine value. For example:
    
 {{{      
[generic_inf72]
Description = Default settings for Informix 7.2 agent
Program     = inf72_sv
Environment = INFORMIX72
OpsysLogin  = Yes
ReUse       = never
CommandLine = +norowsetlimit
}}}
     
* Save the Rulebook, restart your Request Broker, and test.
    
       
* If the 100 row limit is enforced with {{{CommandLine = +norowsetlimit, replace +norowsetlimit with +maxrows=0}}}. For example:
    
{{{  
[generic_inf72]
Description = Default settings for Informix 7.2 agent
Program     = inf72_sv
Environment = INFORMIX72
OpsysLogin  = Yes
ReUse       = never
CommandLine = +maxrows=0
}}}
     
* Restart your Broker and test.
    
    
===Evidence===

Database Agent Version String 
ODBC Client Trace 
Request Broker Log
Request Broker Version String 
Session Rules Book