Re: Updating within a scrolling cursor

In article <1993Jan11.200253.8580@informix.com>, cortesi@informix.com (David Cortesi) wrote: > > 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 > > For Reg Foulkes: why do you want to do this? Perhaps if you explain > what you are trying to accomplish, somebody would have another > suggestion. Why do I want to do this? Well, performance mainly. Here is what I am currently doing now. I have an informix front end (screens & reports) where users can generate there own reports and screens without coding. But now I what to access other databases (oracle, sybase, ingres..etc) dynamically. I do not what to do an unload to and load from some flat file, since if there was heavy traffic I am up a creek without a paddle. So I have to create temp tables to load the data--only to have informix create a temp table of my temp table (for the scrolling cursor) --seems like a waste to me. If there is an easier way of building an interface to different back-ends then I'm not proud, I'll take a hint. riskit@bnr.ca phone (613) 763-4131 Ottawa, Ontario Canada.