# Setup a table with some data
CREATE TABLE updatable_cursor_table(a INT, b SMALLINT, c BIGINT, d TINYINT, e BIT);
INSERT INTO updatable_cursor_table values(0, 0, 0, 0, 0)
INSERT INTO updatable_cursor_table values(NULL, NULL, NULL, NULL, NULL)
INSERT INTO updatable_cursor_table values(1, 2, 3, 4, 1)
INSERT INTO updatable_cursor_table values(211234, 9780, 891372401, 56, 1)

# Try opening an updatable cursor using JDBC API
cursor#!#open#!#SELECT * FROM updatable_cursor_table#!#CONCUR_UPDATABLE#!#CLOSE_CURSORS_AT_COMMIT

# Try opening an updatable (i.e. dynamic) cursor using SQL Batch
DECLARE updatable_cursor CURSOR DYNAMIC FOR SELECT a FROM updatable_cursor_table; OPEN updatable_cursor; CLOSE updatable_cursor; DEALLOCATE updatable_cursor;

# Drop table
DROP TABLE updatable_cursor_table
