Getting return code 100001 from RLX

Products

• RLX SQL

Issue/Introduction

Encountering return code 100001 from RLX.  What does it mean?

Here is the code: 

"rlx declare sysids rexxstem for          ",            
"     select                              ",            
"      EFF_END_TS,                        ",            
"      EFF_START_TS,                      ",            
"      EMP_ID,                            ",            
"      EMP_INSERT_ID,                     ",            
"      EMP_UPDATE_ID,                     ",            
"      INSERT_DATE,                       ",            
"      RESPON_ORDER_SEQ,                  ",            
"      ROLE_EMP_ID,                       ",            
"      SYS_ID,                            ",            
"      SYS_IDEN_CMPNY_CD,                 ",            
"      UPDATE_DATE                        ",            
"     into                               ",             
"     :EFF_END_TS,                        ",            
"     :EFF_START_TS,                      ",            
"     :EMP_ID,                            ",            
"     :EMP_INSERT_ID,                     ",            
"     :EMP_UPDATE_ID,                     ",            
"     :INSERT_DATE,                       ",            
"     :RESPON_ORDER_SEQ,                  ",            
"     :ROLE_EMP_ID,                       ",            
"     :SYS_ID,                            ",            
"     :SYS_IDEN_CMPNY_CD,                 ",            
"     :UPDATE_DATE                        ",            
"     from   creator."tbname"               ",            
"     where :role_emp_id not in           ",            
"     (nnnn, nnnn, nnnn, nnnn, nnnn,      ",            
"      nnnn, nnnn, nnnn, nnnn)            "                  

Resolution

The return code means the maximum number of rows has been exceeded in the execution.

Run the RLXADMIN command from TSO/ISPF option 6 or any TSO command line.   

This should display the "RLX Administration and Customization (V200)" main menu.
(The panel id is RLX@RPA for this screen )

Select Option 2 ->   Defaults    - Specify RLX defaults for the target DB2 subsystem  

This will display panel "RLX System Defaults"  
(The panel id is RLXRTD for this screen )

About 2/3 down this screen, look for the heading: "Default RLX/ISPF CONTROL Settings"
The next line below this heading is a field labeled "Maximum Rows".
The default value is set to 1000.   (This value might have been changed, higher or lower!?.)

Regardless, this value must be increased and should be set higher than the expected number of  rows returned from DB2 for
the indicated "rlx declare sysids rexxstem for select....from  creator."tbname..."  "  statement in the REXX exec they are trying to run.

Once the "Maximum Rows" field is increased and saved, you can try to rerun the REXX again.

After this field is updated on the screen, and the ENTER key is hit, it will prepare a job which can be submitted to make the change
permanently by zapping the RLX$TSD load module in the RLXLOAD (9.1.8) or in the CRAILOAD(20.0) library.