Hi, In my experience there are two basic ways of doing temporary tables, which might be called the "Oracle" model and the "Sybase" model.
In the "Oracle" model, you create the temp table as a static entity - i.e. it's created once and usage local to a transaction is visible to that transaction and not outside the transaction. In the "Sybase" (or SQL-Server) model, creating a temp table is quite a cheap operation and is often done within a stored procedure. The table is destroyed when the transaction is committed or rolled back. Temporary tables are quite an idiomatic thing when writing sprocs in T-SQL. SAP-DB seems to use the "Oracle" model, but the documentation isn't clear on this. If anyone knows off the top of your head, the info might be useful to many on the list. If not, I'll do a little experiment and see. Nigel. _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
