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