if a good record is found do an insert into temp table
select * from temp table
Make sure that you drop the table at the end. If it is a local temp
table (i.e., name starts with '#') then I think it is automatically
dropped at some point anyway, but I'm a stickler for cleaning up after
oneself. Since the table will be local temporary, you shouldn't need
to worry about concurrency issues (anyone want to clarify this?) such
as two users running the same SP and messing with the same temp table.
Just make sure that you don't use '##' as the table name prefix.
3.Loop in the cursor, get the values
4.Insert in Temptable the fetched values
5.Select * from tempTable.
Hope this helps.
Everything I have seen to date seems to indicate that it is not possible
to return a handle/cursor to a result set from a procedure written in
Java. Is this true? Target environment of interest is DB2 UDB.
Note: using techniques similar to the pre-7.3 ORACLE PL/SQL approach to
faking out returning rows is not appropriate for my application.
< 1K Download