Previous Topic: -317 (alternate version) - CURSOR REQUIRED ERROR: CURSOR REQUIRED FOR NON-DYNAMIC SELECTNext Topic: -319 - LUW IS TIMING OUT - TRY AGAIN (LUWID=luw-id-string, TASK=task-nbr, JOB=job-name)

SQL Codes › SQL Return Codes -1 through -999 › -318 - URI=YES IS REQUIRED FOR SQL TO USE TABLE (DATACOM-NAME) ttt DBID nnnn

-318 - URI=YES IS REQUIRED FOR SQL TO USE TABLE (DATACOM-NAME) ttt DBID nnnn

Explanation

Use of SQL requires the ability to execute the ROLLBACK statement. URI=YES is required to perform a ROLLBACK. The ttt is replaced with the three-character CA Datacom name (as opposed to the SQL name) for the table. The nnnn is replaced with the database-ID. These names are reported rather than the SQL name because this is the information you need to run DBUTLTY to correct the problem.

The SQLSTATE that equates to this SQL return code is 55S10.

User Response

The data area containing the problem table must be converted to URI format. For instructions, see the information about converting to URI in the chapter on the LOAD function in the CA Datacom/DB DBUTLTY Reference Guide. The name of the area containing the table in question can be found in a Directory (CXX) report of the problem database.

Note: LOGGING must also be set to YES for the area in which this table resides.