If you always follow that naming convention, you can change your script to
take advantage of it and always SAV/RST the USP_* objects instead of CPYing
them. This will ensure SQL catalogue is updated with the correct
Celebrating 11-Years of SQL Performance Excellence on IBM i, i5/OS and
Subject: Re: view sysprocs and library consolidation
I am not a a procedure expert but -
the person I am dealing with said he named his procedures starting with
USP_ in one of our production libraries.
when I did a dspobjd on the library then did the following query
SELECT ODOBNM, ODOBTP, ODOBAT FROM cat/dspobjd WHERE odobnm like
I got the following results. which I thought were the procedures.
This mailing list archive is Copyright 1997-2019 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