Hi ... Please help as soon as possible...
We have a Global temporary table where we will insert the datas and return the result set to front end by opening the cursor in the stored procedure... We have deletion of GTT at the start of the program.... but we are getting -913 error.. So we thought of commenting it out. If we comment that deletion , then the GTT returns the old datas along with the newly inserted rows.. But as...
birundha
Last Activity: Feb 13 '08, 06:00 AM
Joined: Sep 6 '07
Location:
-
Deleting a Global Temporary table datas
-
Hi... Insertion in to Global temporary tables in db2
Hi... I have created a GTT using the query (this is just a simple eg that i try executing)
EXEC SQL DECLARE TEMP_TABLE TABLE
(
IDP CHAR(10) NOT NULL
)
Can anybody tell me how to insert values in to this Global temporary table??? -
Can stored procedure have call to subroutines
Hi.. Can i call a subprogram (ie a COBOL program) inside a Stored Procedure? -
Stored procedures and Global temporary tables
Hi Hope this will help more peolpe...
We got a new design where we use Global temporary tables(GTT) inside stored procedure... My question is can we use GTT inside a stored procedure and insert values in to it? Can we fetch multiple rows from that GTT and return it from DB2(Note: My stored procedure is created in DB2)?
Please help me out ...
No activity results to display