Re: Updating within a scrolling cursor

Quoting Reg Foulkes... } } 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 } Won't happen. First of all, I don't think you can access a cursor's tmp table. Second, even if you were using a real tmp table, when you execute the RUN command to do the INSERT, a new database process is started. The tmp table from your first database process is not available to any other database processes. Can someone at Informix tell me if I'm way out in left field, or am I pretty much on the money. DAS -- David Snyder @ Snide Computer Services - Folcroft, PA Current Release is db4glgen-3.9 UUCP: ..!uunet!das13!dave INTERNET: dave.snyder@snide.com