Re: Suggestions

How about having RPG SQL do a 'SELECT MAX(field)' into a variable and then
just increment that by one?
_________________________
Daniel L. Gray
Systems Analyst
Maverick Transportation, Inc.
13301 Valentine Road
North Little Rock, AR 72117

Phone: 501-955-1221
Fax: 501-955-4221


                                                                           
             "Douglas W.                                                   
             Palme"                                                        
             <dpalme@blackcats                                          To 
             olutions.com>             RPG programming on the AS400 /      
             Sent by:                  iSeries <rpg400-l@xxxxxxxxxxxx>     
             rpg400-l-bounces@                                          cc 
             midrange.com                                                  
                                                                   Subject 
                                       Suggestions                         
             03/09/2005 01:57                                              
             PM                                                            
                                                                           
                                                                           
             Please respond to                                             
              RPG programming                                              
              on the AS400 /                                               
                  iSeries                                                  
             <rpg400-l@midrang                                             
                  e.com>                                                   
                                                                           
                                                                           




I have a physical file that will hold gas type information, but one of the
fields needs to be an integer id field.  My experience with other db
formats
is that I could set that field to auto generate so that as each record is
written it will increment the count by 1.  we will be using this for cross
referencing to some other files and must be unique.

I know I can read through the file and increment a counter, but that seems
to have a huge overhead, not to mention that as time goes on, it'll take
longer and longer to calculate.

Does anyone have a viable suggestion on how to accomplish this?

Douglas

--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.