Re: Suggestions

Because it would have to read every record to determine that?  Or, is SQL 
got something in the engine that makes it do the rpg equivalent of SETLL 
*HIVAL, READP?

That, and I get the impression that he doesn't have the SQL precompiler.

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





DGray@xxxxxxxxxxxxxxx 
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
03/09/2005 03:42 PM
Please respond to
RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>


To
RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>
cc

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



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