Error: UPDATE FOR READ ONLY TABLE, with a RC 06(006) in Datacom/DB application program

Products

• Datacom
• Datacom/DB

Issue/Introduction

Running a Datacom/DB application program resulted in RC 06(006) error, with a PXX dump and messages:

 	DB02405I - PXX START myjob 363 06(006) SELFR-123-ttt 	
 	DB02406I - PXX END - UPDATE FOR READ ONLY TABLE 

Environment

 

 

Resolution

Here is the error description of the RC 06(006) from the Datacom/DB Message documentation:

Explanation: A command was issued to read a table with update intent or to modify a table for which there was no update authorization.  If your program issues UPDAT, ADDIT, DELET, or RDUxx commands, or issues SELxx commands without using a separate Index Area for temporary indexes (see the MUF startup option CBS parameter for the ID of the database used by the Compound Boolean Selection Facility and SQL), the parameter UPDATE=YES must be specified in the User Requirements Table.

User Response: Change the User Requirements Table definition to permit updating by specifying UPDATE=YES in the DBURTBL macro for the table to be updated, then reissue the request.

To summarize this, it would appear that this error results from using a URT with this program that does not have UPDATE=YES for table ttt in DB 123.

Please check the table definitions for the URT that is being used, and if you have this situation, either use a different URT or update this one accordingly.

Additional Information

As always, please contact Broadcom support for Datacom if you have further questions.