ESQL/C and ESQL/COBOL Usage

EXEC SQL DECLARE cursor_name 
	[SEMI_SENSITIVE | INSENSITIVE] 
	[SCROLL | NOSCROLL] 
	[RELEASE_LOCKS_ON_CLOSE]
	CURSOR FOR “select stmt”
	[for {read only | update [ of column_name_list]}]

You cannot use RELEASE_LOCKS_ON_CLOSE with an UPDATE clause except in this form:

EXEC SQL declare cursor c1 release_locks_on_close
   cursor for select * from T for update of col_a

cpre and cobpre cannot generate these ct_cursor() options:

• CS_CUR_RELLOCKS_ONCLOSE | CS_READ_ONLY

• CS_CUR_RELLOCKS_ONCLOSE | CS_FOR_UPDATE