DB2 SQL Stored Procedures
Posted on 2005-04-01
I'm familiar with how to write Oracle stored procedures. Would someone be willing to write an equivilant DB2 stored procedure for the following:
CREATE OR REPLACE PROCEDURE simple_usp(
p_DlrNumber NUMBER(4)) AS
WHERE Dlr_Num = p_DlrNumber;
This is a very simple procedure I realize but being visual and not being able to find a similar example in all of the DB2/stored proc documentation I've looked at I just need someone to break it down for me.