Re: view sysprocs and library consolidation

[JDHorn@xxxxxxxxxxxxxx]

   Rob
    
   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
   '%USP%'                                                         
    
   I got the following results.  which I thought were the procedures.
    
   Object      Object    Object       
               Type      Attribute    
   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                 
   S1013BCA
                                                                                  
    Library . . . . .   MIS_LIB          Position to . . . . . . .
   .              
                                         Position to type  . . . .
   .              
                                                                                  
    Type options, press
   Enter.                                                    
      2=Change       3=Copy        4=Delete      5=Display      
   7=Rename         
      8=Display description        9=Save       10=Restore      11=Move
   ...       
                                                                                  
    Opt  Object      Type        Attribute  
   Text                                 
         USP_C00001  *PGM        CLE         SQL PROCEDURE
   USP_CREATESALESTABLES  
         USP_C00002  *PGM        CLE         SQL PROCEDURE
   USP_CLEANUP_TMPSALESDAT
         USP_G00001  *PGM        CLE         SQL PROCEDURE
   USP_GETSALESMENSUMMARIZ
         USP_G00002  *PGM        CLE         SQL PROCEDURE
   USP_GETSALESMENSUMMARIZ
         USP_T00001  *PGM        CLE         SQL PROCEDURE
   USP_TMPSALESDATA       
    
   these were copied with the cpy cmd and technique I descriped before.
    
   thanks   
    
     
   Jim Horn

   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.
     
    
   ----------------------------------------------------------------------

   message: 1
   date: Wed, 10 Sep 2008 09:40:12 -0400
   from: rob@xxxxxxxxx
   subject: Re: MIDRANGE-L Digest, Vol 7, Issue 1803

   The situation is that stored procedures, user defined functions, etc, do
   NOT exist in
   wrklnk '/qsys.lib/mylib.lib'
   and also do not appear in a DSPOBJD.  Therefore
   A - Since they don't appear in a DSPOBJD they won't appear to "read
   outfile"
   B - Since they don't appear in wrklnk then CPY will have no effect.

   They really only exist in SYSPROCS and SYSFUNCS.

   Rob Berendt
   --
   Group Dekko Services, LLC
   Dept 01.073
   Dock 108
   6928N 400E
   Kendallville, IN 46755
   http://www.dekko.com