Re: [sqr-users] TEMPORARY TABLES

["Jerry Coleman" <colemanj@washpost.com>]

I assume this is a PeopleSoft app, right?  Consider adding a column
containing $prcs_process_instance to the table, then delete rows pertaining
to the process instance at the end of the SQR.




|---------+---------------------------->
|         |           "Hood Louise     |
|         |           (app1lxh)"       |
|         |           <app1lxh@ups.com>|
|         |           Sent by:         |
|         |           sqr-users-admin@s|
|         |           qrug.org         |
|         |                            |
|         |                            |
|         |           04/08/03 12:14 PM|
|         |           Please respond to|
|         |           sqr-users        |
|         |                            |
|---------+---------------------------->
  
>--------------------------------------------------------------------------------------------------------------|
  |                                                                             
                                 |
  |       To:       sqr-users@sqrug.org                                         
                                 |
  |       cc:                                                                   
                                 |
  |       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