×
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.
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?
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
