Error Messages (M)
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z #
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
OpenLink Request Broker Rulebook, oplrqb.ini, in a text editor. This file is typically found in the /bin/ sub-directory of your 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
CommandLine (as this makes the line a comment, and the value then has no effect).
- If not present, add +norowsetlimit to the
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