Re: Updating within a scrolling cursor

In article <1ik9fsINNhbe@emory.mathcs.emory.edu>, dave.snyder@snide.com (Dave Snyder) wrote: > > 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. Sorry but you are mistaken. Currently, I can create my own tmp table and it works fine. I just wanted to bypass that step and go directly to the temp table created by the open and do an insert before a fetch. This saves me from creating the temp table. That I use for the fetch. Unfortunately, informix hides its' system temp tables so I am unable to use them. Why? riskit@bnr.ca phone (613) 763-4131 Ottawa, Ontario Canada.