RE: [Info-ingres] ABF - temp tables and exec sql connect question s...

Hi Manny

The temp table is not destroyed, just that it's 'scope' is limited to the db
session in which it was created.

If you want to 'merge' data from 2 db sessions into one session table you
will have to store the data from the 2nd session in a program array or flat
file, then switch back to the 1st session to do the insert.

HTH
Dave

-----Original Message-----
From: Manny [mailto:mantas44@xxxxxxxxxxx]
Sent: 14 June 2006 10:44
To: info-ingres@xxxxxxxxxxxxxxx
Subject: [Info-ingres] ABF - temp tables and exec sql connect
questions...


Hello all,

I have created a frame in which I am using db1 and have declared a
temporary table SESSION.accounts.
I then connect to another another db (db2) using 'exec sql connect' in
order to retreive some data. I select the data successfully and then
attempt to load it into the temp table SESSION.accounts. But this
fails.
I am guessing that the temp table SESSION.accounts is destroyed as soon
as I connect to db2 - how can I get round this and retreive data from
db2 and use it in db1 in the frame.

Cheers,

Manny

_______________________________________________
Info-ingres mailing list
Info-ingres@xxxxxxxxxxxxxxx
http://mailman.cariboulake.com/mailman/listinfo.py/info-ingres


**********************************************************************

The information contained in this e-mail is confidential and intended only
for the use of the addressee. If the reader of this message is not the
addressee, you are hereby notified that you have received this e-mail in
error and you must not copy, disseminate, distribute, use or take any action
as a result of the information contained in it.

If you have any queries, please contact the IT Service Desk on 1870
(01384-275454).

postmaster@xxxxxxxxxx

**********************************************************************


**********************************************************************

This e-mail is provided for general information purposes only and does not constitute investment or transactional advice. For the avoidance of doubt the contents of this email are subject to contract and will not constitute a legally binding contract.

The information contained in this e-mail is confidential and intended only for the use of the addressee. If the reader of this message is not the addressee, you are hereby notified that you have received this e-mail in error and you must not copy, disseminate, distribute, use or take any action as a result of the information contained in it.

If you have received this e-mail in error, please notify postmaster@xxxxxxxxxx (UK 01384 275454) and delete it immediately from your system.

Neither Npower nor any of the other companies in the RWE Npower group from whom this e-mail originates accept any responsibility for losses or damage as a result of any viruses and it is your responsibility to check attachments (if any) for viruses.
Npower Limited Registered office: Windmill Hill Business Park, Whitehill Way, Swindon SN5 6PB. Registered in England and Wales: number 3653277. This e-mail may be sent on behalf of a member of the RWE Npower group of companies.

**********************************************************************

.

Relevant Pages

  • Re: linking a research form with a display page
    ... But if the webmaster will delete the record n°4, ... do I need to delete the temp table) or an other solution to do things ... and when the session is closed the temp table dies. ... this king of search->browse in display ...
    (comp.lang.php)
  • Re: linking a research form with a display page
    ... I have a page rech.php where I'm doing a multi-criteria research Ex. ... do I need to delete the temp table) or an other solution to do things ... Depending on your database, you can create a persistent session, ...
    (comp.lang.php)
  • Re: temporäre Tabellen
    ... Tabellen werden vom SQL-Server je Session verwaltet. ... hierbei der Session Bezug, d. h. die A Session sieht nichts von der B ... verwenden, die temp. ... Dabei können die @temp Tables auch einige Vorteile gegenüber den ...
    (microsoft.public.de.sqlserver)
  • Re: Sessions using TEMP and sharing extents
    ... temp the single sort segment per node is shared but extents allocated ... within the segment are used by one session at a time. ... traditional dictionary management each session allocates its own ... Does this mean that with a locally managed Temp tablespace there is ...
    (comp.databases.oracle.server)