NetNews Usenet Archive 1993 #1/NN_1993_1.iso/spool/comp/database/informix/2915

Text File | 1993-01-11 | 1.7 KB | 46 lines

Newsgroups: comp.databases.informix
Path: sparky!uunet!utcsri!torn!nott!bnrgate!bcars267!zoonews!NewsWatcher!user
From: [e-mail] (Reg Foulkes)
Subject: Re: Updating within a scrolling cursor
Message-ID: <riskit-110193091454@47.201.0.36>
Followup-To: comp.databases.informix
Sender: [e-mail] (Patrick Wall)
Nntp-Posting-Host: bftzm17
Organization: Bell-Northern Research
References: <[e-mail]>
Date: Mon, 11 Jan 1993 14:14:52 GMT
Lines: 32

In article <[e-mail]>, [e-mail]
(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?

[e-mail]
phone [phone]
Ottawa, Ontario Canada.