|
What package is that?
Subject: Re: Identity Columns
How do you define the table? I have an assets table that uses an asset ID that gets created when the record is written in my RPGLE program with a regular write statement. Field is defined as follows
create table Assets.Assets (Asset_ID for column ASAssetID integer not null generated always as identity (start with 1 increment by 1), ...
When I write the new record with RPGLE program, the asset_ID field value is automatically created and incremented by 1 from the last Asset_ID field that was previously added to the file. I believe that I initially tested this with Ezview, but don't remember for sure as it was a couple of years ago.
Dave Murvin DRM Enterprises, Inc.
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.