udb cursor (or curser)

[MCPHEAL]

I'm not that familiar with UDB, so apologies for my naivety.

One of our developers approached me with a sql question. I thought a cursor
loop would do the job - but I had difficulty getting a simple template to work.

Can one use cursors within a file like this ?

$ db2 -tvf cursor
DECLARE table_cursor CURSOR FOR SELECT name FROM sysibm.systables
DB20000I The SQL command completed successfully.

OPEN table_cursor
DB20000I The SQL command completed successfully.

FETCH table_cursor
DB21030E The cursor "TABLE_CURSOR" has not been opened.

Any constructive advice most welcome, thanks.

[dotyet]

why not put the steps in a stored procedure and execute the procedure.
regards,
dotyet

[Serge Rielau]

MCPHEAL wrote:

I'm not that familiar with UDB, so apologies for my naivety.

One of our developers approached me with a sql question. I thought a cursor
loop would do the job - but I had difficulty getting a simple template to work.

Can one use cursors within a file like this ?

$ db2 -tvf cursor
DECLARE table_cursor CURSOR FOR SELECT name FROM sysibm.systables
DB20000I The SQL command completed successfully.

OPEN table_cursor
DB20000I The SQL command completed successfully.

FETCH table_cursor
DB21030E The cursor "TABLE_CURSOR" has not been opened.

Any constructive advice most welcome, thanks.

Try this:
db2 +c -tvf cursor
By default CLP operates under auto-commit so your cursor (not being
defined as WITH HOLD) closed right after being opened.
+c suspends auto commit

Cheers
Serge