RE: [sqr-users] TEMPORARY TABLES

[Harish_Venkiteswaran@Satyam.com]

Hi,
        Estending what Torres wrote.

        I presume you are working in peoplesoft Database.

        You need to create a table which has a process instance and oprid as
a key.That way you could get the data based on that particular instance and
the oprid that has run the report.Consider the scenarios that 2 user are
running the report.

Table1
Oprid-Key
Process Instance-Key
Key1-Key
Nonkey1

When 1st user runs the report.The oprid would be updated as User1 and
Process Instance - Current Process Instance for that report
When 2nd user runs the report .The oprid would be updated as User2 and
Process Instance - Current Process Instance for that report.

You can code the select for the temporary table as

SELECT KEY1,NONKEY1 FROM TABLE1 WHERE OPRID=$USER AND
PROCESS_INSTANCE=$PRCSINSTANCE

Using a single table you can segregate the data relevant for each user.

Regards
Harish


> --Original Message-----
> From: Hood Louise (app1lxh) [SMTP:app1lxh@ups.com]
> Sent: Tuesday, April 08, 2003 9:45 PM
> 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
************************************************************************** 
This email (including any attachments) is intended for the sole use of the
intended recipient/s and may contain material that is CONFIDENTIAL AND
PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or
distribution or forwarding of any or all of the contents in this message is
STRICTLY PROHIBITED. If you are not the intended recipient, please contact
the sender by email and delete all copies; your cooperation in this regard
is appreciated.
**************************************************************************

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