Re: Program Cross reference file

[SCarter@xxxxxxxxxxx]

Thanks for the comments Vern. I will have to do a bit of work after all ;->
I do need to create a system soon.  What happens is each developer does the
dspobjd and after the information is gathered the file is forgotten and
never cleared.  This causes a headache because the next time the developer
does DSPOBJD they will probably create with a different name causing
versions of DSPOBJD *OUTFILE to propagate like rabbits...


____________________________________________________

J. Scott Carter
Programmer/Analyst
e-mail: Mailto:scarter@rsrcorp.com
Phone: 214.583.0348

It's not the destination that counts in life it's the journey. The journey
with the people we love is all that really matters. Such a simple truth so
easily forgotten.


                                                                                
                                                               
                      Vern Hamberg                                              
                                                               
                      <vhamberg@centerfieldtech        To:       Midrange 
Systems Technical Discussion <midrange-l@midrange.com>               
                      nology.com>                      cc:                      
                                                               
                      Sent by:                         Subject:  Re: Program 
Cross reference file                                              
                      midrange-l-bounces@midran                                 
                                                               
                      ge.com                                                    
                                                               
                                                                                
                                                               
                                                                                
                                                               
                      02/04/2003 09:50 AM                                       
                                                               
                      Please respond to                                         
                                                               
                      Midrange Systems                                          
                                                               
                      Technical Discussion                                      
                                                               
                                                                                
                                                               
                                                                                
                                                               




This makes me think you could do the DSPFD type(*MBRLIST) against all
source files you are interested in (could be generated from the DSPOBJD
list, as the x-ref products do, at least). You might want to correlate
these lists together somehow.

To find gaps in the names, you can go through them in order, checking that
each one is in sequence with the previous one. Control level processing in
RPG could be useful, I would think.

You might be able to cobble together an SQL statement that returns a record

where the sequence number (substrung and converted to numeric) is more than

1 higher than the max of that sequence number for all records with the name

less than the one from the current record. It feels doable with subqueries
- don't have time to work out the details. You'd group, possibly on the
first 3 characters, if your naming convention is really well-managed.

HTH

Vern