Inserting into Global temporary table

mssabirami · New User Joined: 11 Feb 2008 Posts: 17 Location: Chennai

Hi,

I have an insert statement in my program.
INSERT INTO SESSION.LOOKUPTAB

(GTLKUP_DEP_BLL_BAS,
GTLKUP_RATE_TYPE,
GTLKUP_BAC_COVER
)

VALUES
(:TRBNDCD-DEPS-BEN-BIL-BAS,
:TRBNDCD-RATE-TYPE,
:TRBNDCD-BAC-COVERS

)
Values are available for all the three host variables and the SQLCODE returned is +000000. But when i used a selest query
SELECT GTLKUP_DEP_BLL_BAS,GTLKUP_RATE_TYPE,
GTLKUP_BAC_COVER INTO :TMP-DEP-BLL,
:TMP-RATE-TYPE,:TMP-BC-CVR
FROM SESSION.LOOKUPTAB
to view the content of the table, i found that nothing was inserted into the temporary table.

I dont know what is the problem with insert....
Can any one please help me..

Thanks in advance.

sivatechdrive · Posted: Tue Mar 25, 2008 4:25 pm

Please check the below link

ibmmainframes.com/about123.html

the default, is ON COMMIT DELETE ROWS. In that case all of the rows of the table are deleted as long as there are no cursors defined using WITH HOLD.

also Issue a commit statement after insert

sivatechdrive · Posted: Tue Mar 25, 2008 4:28 pm

Additional link :
==========

decipherinfosys.wordpress.com/2007/05/05/temporary-tables-db2-luw/

mssabirami · New User Joined: 11 Feb 2008 Posts: 17 Location: Chennai

Hi siva,

I have already used both "ON COMMIT PRESERVE ROWS" and "COMMIT" after insert statement. Then also its not working.

And iam not using any cursor.

What to do now?
How to resolve this problem?
Iam not able to progress.
Please anyone help me..

birdy K · New User Joined: 05 Mar 2008 Posts: 72 Location: chennai

Simple. Use display statement after insert and before select