Using DB2 interface receive message: THERE WAS A DB2 ERROR IN THE SELECT CURSOR: 100001

Products

• RLX

Issue/Introduction

From our DB2/REPO application :

Logged out and logged back in and now now receiving errors. No SQL errors can be seen.   This is what we see:  THERE WAS A DB2 ERROR IN THE SELECT CURSOR: 100001

 

 

Environment

Release : 9.1.8

Component : RLX/DB2 Extensions or RLXISPF

 

Resolution

There are 2 options.

1. As already mentioned, Section 6.2 of the RLX Installation and Customization Guide describes how this limit can be changed  in the RLX$TSD load module.

-OR-

2. In the application REXX exec, right before the "RLX DECLARE" statement, the following RLX command can be inserted to serve as an override:

   RLX CONTROL LIMIT nnnn                                 /* Increase MAX    ROW LIMIT */

   RLX DECLARE A120ABTB ISPFTABLE FOR SELECT....

  RLX CONTROL LIMIT <previous value/default>      /* Reset MAX ROW LIMIT  */

 Where nnnn is a value greater than the current value specified in the RLX$TSD load module.  

(This is,  a value > 1000 if the default value is still operational)