Previous Topic: -317 - CURSOR cursor-name ERROR: MULTIPLE stmt-type STATEMENTS ATTEMPTEDNext Topic: -318 - URI=YES IS REQUIRED FOR SQL TO USE TABLE (DATACOM-NAME) ttt DBID nnnn

SQL Codes › SQL Return Codes -1 through -999 › -317 (alternate version) - CURSOR REQUIRED ERROR: CURSOR REQUIRED FOR NON-DYNAMIC SELECT

-317 (alternate version) - CURSOR REQUIRED ERROR: CURSOR REQUIRED FOR NON-DYNAMIC SELECT

Explanation

Non-dynamic SELECT statements must be embedded in a DECLARE CURSOR statement.

User Response

Embed the SELECT in a DECLARE CURSOR statement.