in Ingres II, how can I know which temporary tables are currently existing
(name, session) ?
I create some temp tables with "DECLARE GLOBAL TEMPORARY TABLE"
and I want to make sure they disappear when my client crashes.
There's no way to list all the temporary tables for a session.
You can check for the existence of a specific temporary table
by doing a bogus trial select and checking for an error code.
(I use a garbage column name and check for "invalid table"
vs "invalid column".)
If you are just concerned about the tables going away, though,
don't worry; as long as the server detects that the client
is gone, and closes the session thread, any temporary tables
will definitely be deleted.
Listing temporary tables ... in Ingres II, how can I know which temporary tables are currently existing ... (name, session) ... I create some temp tables with "DECLARE GLOBAL TEMPORARY TABLE" ... and I want to make sure they disappear when my client crashes.... (comp.databases.ingres)
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: [Info-ingres] ABF - temp tables and exec sql connect question s... ... The temp table is not destroyed, just that it's 'scope' is limited to the db ... If you want to 'merge' data from 2 db sessions into one session table you ... as I connect to db2 - how can I get round this and retreive data from ... 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 for viruses. ... (comp.databases.ingres)
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)
