Remote Stored Procedures and Temporary Tables

Posted in 1996

Carol Davies — 7 Nov 1996 13:34:54 -0500 — source: Informix-list mailing list archive (1991-1998)

Are temporary tables (which are created under the currently "connected to" database, e.g. server1@site1) accessible via a remote stored procedure that is invoked via the statement EXECUTE PROCEDURE server2@site2:my_spl? In other words, if the my_spl procedure has insert statements in it to a table named "TEMP" which was created under server1@site1, will they work as intended? I know that if you explicitly CONNECT in the middle of a program, temp tables are blown away, and if you use dynamic SQL like SELECT ...FROM database@sitename the temp tables will remain intact, but I'm not sure about Stored Procedure Objects. Thanks. -- Carol Davies cdavies@csc.com