RC/Update : Data Query Edit receives -438 S04E when removing a column

Products

• Database Management for DB2 for z/OS - Administration Suite
• RC/Migrator for DB2 for z/OS
• RC/Query for DB2 for z/OS
• RC/Update for DB2 for z/OS

Issue/Introduction

Relates to DB2 Tools R20.  When using a Data Query Edit, and unselecting columns, the following message occurs;

 

DSNT408I SQLCODE = -438, ERROR:  APPLICATION RAISED ERROR WITH                

          DIAGNOSTIC TEXT: PTABDBS: PTLBDBC subtask has abended: S04E          

 DSNT412I SQLCABC    = 131 SQLCA BYTE COUNT                                    

 DSNT418I SQLSTATE   = 00000 SQLSTATE RETURN CODE                              

 DSNT416I SQLERRD    = 310944  0  0  1  0  0 SQL DIAGNOSTIC INFORMATION        

 DSNT416I SQLERRD    = X'0004BEA0'  X'00000000'  X'00000000'                   

          X'00000001'  X'00000000'  X'00000000' SQL DIAGNOSTIC                 

          INFORMATION                                                           

 DSNT417I SQLWARN0-5 = .,.,.,.,.,. SQL WARNINGS                                

 DSNT417I SQLWARN6-A = .,.,,,   SQL WARNINGS    

 

The Data Query Edit works if no columns are removed.

Environment

Release : 20.0

Component : CA RC/Update for DB2 for z/OS

Resolution

Apply PTF LU02211

Workaround:

Do the following:

> From the Database Management Solutions for DB2 Main Menu,  enter Option 3 - RC/Update.

> From the RC/Update Main Menu enter 'Profile' on the command line, then Option 3 RC/Edit Profile Variables

> Set the RC/Edit parameter 'Default method for applying  updates' to 'P' for positional updates and browse the table.     

 

 

There is not a Global parameter for this in the RCEDIT parmlib member. It must be changed by each user.