Temp tables
Igor asked how temp tables differ from normal tables when passing results back from an executable run by a stored procedure. Art S. Kagel said temp tables last only for the session, are invisible to other sessions, and their names are not in the global namespace. san suggested the exit status or static tables keyed by session id. Robert Taylor advised WITH NO LOG if no transactions are needed.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Hi All I am trying to find the best way to get some result back to Stored Procedure running executable which make database i/o. I would like to use temp tables. I wanted to know what difference between normal tables in db and temp tables? Regards Igor
Temp tables exist only for the current session's lifetime and are not excessable by any other session. Also temp table names are not part of the global object name space and so multiple users may create the same temp table name concurrently without problems. Art S. Kagel Igor wrote: > > Hi All > > I am trying to find the best way to get some result back to Stored > Procedure running executable which make database i/o. > I would like to use temp tables. > I wanted to know what difference between normal tables in db and temp > tables? > > Regards > > Igor
You can use exit status of your executable to return result to SP. You can read result from static tables in context of this exit status. Second way use unique session identifier of user thread that executes specified SP. -- Andrew Svikhnushin Inist Ltd. E-mail: san@inist.ru Igor <i.sokolsky@geac.com> wrote in message news:37bab0ae.150265907@news.ca.geac.com... > Hi All > > I am trying to find the best way to get some result back to Stored > Procedure running executable which make database i/o. > I would like to use temp tables. > I wanted to know what difference between normal tables in db and temp > tables? > > Regards > > Igor
I would say make sure you use WITH NO LOG on the CREATE TEMP TABLE statement , if you can be sure you don't need to perform transactions on the temp table.