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.
Object Object Object
USP_C00001 *PGM CLE
USP_C00002 *PGM CLE
USP_G00001 *PGM CLE
USP_G00002 *PGM CLE
USP_T00001 *PGM CLE
are they something else?
when i use strpdm to view objects I get this
Work with Objects Using PDM
Library . . . . . MIS_LIB Position to . . . . . . .
Position to type . . . .
Type options, press
2=Change 3=Copy 4=Delete 5=Display
8=Display description 9=Save 10=Restore 11=Move
Opt Object Type Attribute
USP_C00001 *PGM CLE SQL PROCEDURE
USP_C00002 *PGM CLE SQL PROCEDURE
USP_G00001 *PGM CLE SQL PROCEDURE
USP_G00002 *PGM CLE SQL PROCEDURE
USP_T00001 *PGM CLE SQL PROCEDURE
these were copied with the cpy cmd and technique I descriped before.
This email is intended only for the person or entity
to which it is addressed and may contain information
that is privileged, confidential or otherwise protected
from disclosure. If you are not the named addressee
or an employee or agent responsible for delivering
this message to the named addressee, you are not
authorized to read, print, retain copy, and disseminate
this message or any part of it. If you have received this
message in error please notify us immediately by email,
discard any paper copies and delete all electronic files
of this message.
date: Wed, 10 Sep 2008 09:40:12 -0400
subject: Re: MIDRANGE-L Digest, Vol 7, Issue 1803
The situation is that stored procedures, user defined functions, etc, do
NOT exist in
and also do not appear in a DSPOBJD. Therefore
A - Since they don't appear in a DSPOBJD they won't appear to "read
B - Since they don't appear in wrklnk then CPY will have no effect.
They really only exist in SYSPROCS and SYSFUNCS.
Group Dekko Services, LLC
Kendallville, IN 46755