Getting return code 100001

book

Article ID: 223741

calendar_today

Updated On:

Products

RLX SQL

Issue/Introduction

I'm getting return code 100001.  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   sis."tb2unlod"               ",            
"     where :role_emp_id not in           ",            
"     (1801, 1802, 1810, 1831, 1832,      ",            
"      1833, 1900, 1910, 1930)            "                             

Environment

Release : 9.1.8 and above

Component : RLX/SQL

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 [email protected] 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  sis."tb2unlod... "  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 (V918) or in the CRAILOAD(V20.0) library.