RE: [sqr-users] TEMPORARY TABLES

["Lock, Edward J" <EJLock@Central.UH.EDU>]

This works in Oracle 8i:

!test sql-----------------------------------

CREATE global temporary TABLE test2
(ord_id    NUMBER(3),
ord_date  DATE, cust_code VARCHAR2(3),
date_of_delay  DATE)

!-------------------------------------------

By default, it puts it in the system tablespace, but this can be changed.

--Edward Lock


-----Original Message-----
From: Hood Louise (app1lxh) [mailto:app1lxh@ups.com]
Sent: Tuesday, April 08, 2003 11:15 AM
To: sqr-users@sqrug.org
Subject: [sqr-users] TEMPORARY TABLES


Hi All,

Has anyone had any experience (or luck) with creating temporary tables that
are unique for each user running a report?  I have an sqr  in which a
temporary table is created in the setup section.  Within the program,
calculations are performed and results stored in the table for later
selection and manipulation.   The sqr works fine as long as someone else
doesn't try to generate the report while another user has already kicked the
program off (the table is already in use and not accessible since it doesn't
have a unique name).

We are using Oracle 8i and sqr 6.0.

I searched the sqrug archives, finding references to CREATE GLOBAL TEMPORARY
TABLE, which I also tried without success. It was referred to in a response
for DB2 environment, so maybe Oracle doesn't recognize this?

There is virtually nothing in the SQR reference manuals and user guide re:
temp tables, so if anyone has been there before and conquered this problem,
I'd appreciate your input.

Thanks,
Louise


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users