RE: [sqr-users] TEMPORARY TABLES

["Torres, Jennifer" <torres@colostate-pueblo.edu>]

Louise,

We have handled this in a couple of ways:
1-
We create unique temporary tables for each execution of the sqr.  For example 
the table is appended with unique value such as username or date/time.  The 
table name is then created in the sqr and referenced with [$table_name] in sql 
statements.

2-
We have used one temporary table for all sqr user executions.  Enabled by 
adding columns to the table to identify the unique users (ie USERNAME).  Sql 
statements then use the USERNAME to reference only rows related to that 
specific sqr execution.

Hope that helps.

-----Original Message-----
From: Hood Louise (app1lxh) [mailto:app1lxh@ups.com]
Sent: Tuesday, April 08, 2003 10: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