|
Douglas, Im sure I read somewhere that this feature is available in V5R3 of DB2/400 cheers Colin.W http://as400blog.blogspot.com -----Original Message----- From: Douglas W. Palme [mailto:dpalme@xxxxxxxxxxxxxxxxxxxxx] Sent: 09 March 2005 19:57 To: RPG programming on the AS400 / iSeries Subject: Suggestions 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 e-mail has been sent by a company of Bertram Group Ltd, whose registered office is 1 Broadland Business Park, Norwich, NR7 0WF. This message, and any attachments, are intended solely for the addressee and may contain privileged or confidential information. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. If you believe that you have received this email in error, please contact the sender immediately. Opinions, conclusions and statements of intent in this e-mail are those of the sender and will not bind a Bertram Group Ltd company unless confirmed in writing by a director independently of this message. Although we have taken steps to ensure that this email and any attachments are free from any virus, we advise that in keeping with good computing practice the recipient should ensure they are actually virus free.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.