Are you against writing the whole thing in the stored procedure?
I can give you a sample of where I'm doing the same thing.
-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Matt Lavinder
Sent: Monday, May 23, 2011 5:06 PM
To: rpg400-l@xxxxxxxxxxxx
Subject: Stored Procedure with Temporary Table
I have a SQLRPGLE procedure (service program) that I am calling from a
stored procedure. I declare a global temporary table, do an SQL to insert
data, process the data and modify the data, do a select all on the temporary
table, and use SET RESULT SETS to set the cursor to be returned from the
stored procedure to that final select.
It was all working fine until a changed the layout of the temporary table.
When I test the procedure in RUN SQL Scripts, it returns the results without
my new column. If I then query my temporary table directly from the same
session, I see the new column in the temporary table itself. So it appears
that the table is defined correctly, but somewhere the procedure is using a
cached(?) copy of the table definition when it returns the results. I have
never seen this before.
Any thoughts?
--
This is the RPG programming on the IBM i / System i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at
http://archive.midrange.com/rpg400-l.
________________________________
Notice from Bob Evans Farms, Inc: This e-mail message, including any attachments, may contain confidential information that is intended only for the person or entity to which it is addressed. Any unauthorized review, use, disclosure or distribution is strictly prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message and any attachments.
midrange.com
