Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Trigger / Stored Procedure problem
I am trying to get a simple trigger that calls a stored procedure to work. Both the trigger and the stored procedure get created successfully using SPUFI. However, I am running into an error when I insert the row to fire the trigger. It seems that DB2 can't access or load the procedure being... -
Stored procedure
Thanks! This was exactly the problem. Found out you can also use the following statement to set the terminator to a value other than the default semicolon. --#SET TERMINATOR # Thanks again for the help -
identity columns and identity_val_local function
We are trying to find a way using DB2 7.1 to create a unique sequence column in a table. One of the criteria is that this sequence column will be the key of one table and a foreign key of another. DB2 has an identity column feature which allows you to create a table with a column that... -
Stored procedure
We are new to loading DB2 stored procedures and are having difficulties with our first attempt. Here is the stored procedure we are trying to load... CREATE PROCEDURE SC80_IP( IN TBL_NAME CHAR(18), IN DLR_NBR CHAR(5), OUT SEQ_NBR DECIMAL(31,0)) LANGUAGE SQL MODIFIES SQL DATA BEGIN UPDATE...
