×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
Thanks Elvis! Exactly what I needed.
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[
mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Elvis Budimlic
Sent: Thursday, July 12, 2007 3:40 PM
To: 'Midrange Systems Technical Discussion'
Subject: RE: DB2/400 Stored Procedures
Mike,
Check out sql COMMENT command:
http://publib.boulder.ibm.com/infocenter/iseries/v5r4/topic/db2/rbafzmst
comn
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?
midrange.com
