RE: DB2/400 Stored Procedures

["Elvis Budimlic" <ebudimlic@xxxxxxxxxxxxxxxxxxxxxxxxx>]

Mike, 

Check out sql COMMENT command:

http://publib.boulder.ibm.com/infocenter/iseries/v5r4/topic/db2/rbafzmstcomn
t.htm

For example:

COMMENT ON SPECIFIC ROUTINE QGPL.PROC2 IS 'This is description for Proc2'

Elvis

Celebrating 10-Years of SQL Performance Excellence
http://centerfieldtechnology.com/training.asp

-----Original Message-----
Subject: DB2/400 Stored Procedures

When you look at a stored procedure in Navigator there is a Description
field for the procedure and one for each of the parameters. In STRSQL on
the CREATE PROCEDURE command there does not appear to be any way to
enter anything into either of these fields. Navigator lets you update
the description of the procedure but not the description on the
parameters but doing this will remove the description when you drop and
recreate the procedure. We are looking to use these description fields
to document our procedures. Has anyone found a way to use these two
descriptions from a CREATE PROCEDURE command?