SQR and Stored Procedure

[James Bowie <jpbowie@HOTMAIL.COM>]

Does anyone have experience with creating a temporary table in a stored
procedure and referencing it from within SQR?

My Problem:

I have a stored procedure that performs several table updates and generates
2 temporary tables.  One table is for data that cannot be updated or added
because it contains errors, and the second is a table for new information
that has been added/updated to the permanent tables.  I need to reference
these temporary tables in an sqr program to generate two reports (obviously
an error report and a report containing data that has changed).  I have
created an SQR program that uses the EXECUTE statement with a -C option to
specify the connection.  I then use two BEGIN-SELECT statements with a -C
option to select the information from my temporary tables.  When I execute
the code, I get an error stating that the temporary tables do not exist.  I
have searched through the archives for this mailing list and have tried the
solutions suggested there, none seem to work.  Any suggestions?

My Environment:

AIX v4
SQR v4.0.1.1
SYBASE 11.5.1

Thanks,
James Bowie

______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com