RE: view sysprocs and library consolidation

MOVOBJ is definitely the worst option, as catalogues are not updated,
meaning they're now reflecting incorrect information (external program name
is incorrect). One 'might' still be OK (i.e. SP still functions), if the
system's cross reference includes resolved address to the object instead of
looking up the external object by name, but I am not familiar with the
internal implementation of this particular processing.

I'm confident neither CRTDUPOBJ nor CPYLIB will effect the registration
either, so I doubt the QLICRDUP api will (but haven't ever used the API, so
don't know for sure).

I know that SAV/RST will work, as long as the internal 'mark' count of 32
has not been exceeded for the object (talking *SRVPGM here). If mark has
been exceeded, only the max of 32 will be registered.

Here's a good article discussing this process:

http://www.mcpressonline.com/programming/sql/procedures-and-functions-and-ca
talogs-oh-my.html

HTH, Elvis

Celebrating 11-Years of SQL Performance Excellence on IBM i, i5/OS and
OS/400
www.centerfieldtechnology.com


-----Original Message-----
Subject: Re: view sysprocs and library consolidation

MOVOBJ [AFaIK still] would not effect registration into the catalog
[nor removal of the old], but I believe CRTDUPOBJ will. I would expect
that the CPY would effect invocation of the QLICRDUP [i.e. CRTDUPOBJ]
for a request performed on a /QSYS.LIB object, so the outcome I would
expect to be the same.?

Although "SQL procedures" was noted, often External SQL procedures is
meant or included. For external procedures, if either the procedure was
created before the program or the program [attribute, e.g. CLP] does not
support the registration of the SQL information on the object itself
[i.e. registration is only into the catalog], then even the save\restore
of one of those objects would not assist to get the procedure registered
in the catalog. For external procedures in those cases, the CREATE
PROCEDURE EXTERNAL NAME must be performed again, and DROP SPECIFIC
PROCEDURE to rid of the old procedure.

Regards, Chuck