SQLCODE = -607 when attempting to Edit table e.g. SYSIBM.LULIST via RC/Update
search cancel

SQLCODE = -607 when attempting to Edit table e.g. SYSIBM.LULIST via RC/Update

book

Article ID: 32031

calendar_today

Updated On:

Products

RC/Update for DB2 for z/OS

Issue/Introduction

Encountering SQL-607 when trying to edit a catalog table via RC/Edit within RC/Update for Db2 for z/OS (RCU):

SQLCODE = -607, ERROR:  OPERATION OR OPTION LOCK IS NOT 
DEFINED FOR THIS OBJECT 

Cause

The SQLCODE = -607 has most often been seen when editing with Update Method = P (positional) and the field 'Lock Table for Edit' field set to Y.

Resolution

Overwrite ‘Update Method’ and set it to S or D.
Both fields are shown on the ‘RC/Edit Options’ panel.

 

Additional Information

You can change the default value by issuing command ‘PROFILE’ then select option 3 -  RC/Edit Profile Variables.
The ‘'Lock Table for Edit' field is defined in member RCEDIT in the highlvl.CDBAPARM library.

The default values can also be set in member DEFAULTS in the CDBAPARM library.

Attachments

1558699045221000032031_sktwi1f5rjvs16oie.bmp get_app