Updating within a scrolling cursor
Posted in 1993
Reg Foulkes — — source: Informix-list mailing list archive (1991-1998)
I would like to access the temporary file created by the a scrolling cursor. Anyone know how to do this (i.e. what is the mystery table name)? Here is what I would like to do Declare scrolling cursor sel_stmt Open sel_stmt RUN "insert into mystery_table VAULES (....) | isql database - -" ^^^^^^^^^^^^^ FETCH next sel_stmt I am aware the I could create a scrolling cursor on an indexed column in a query set. And then do all FETCHES, UPDATES and DELETS on the actual table using the scrolling cursor as an index into the database. riskit@bnr.ca phone (613) 763-4131 Ottawa, Ontario Canada.