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