RE: Identity Columns -- RPG400-L

It's a home grown application that lets me keep track of business assets for the King County, Washington Personal Property Taxes. Personal Property Taxes apply to businesses only and are based on your business assets such as telephones, computers, packaged software, professional books, furniture, office machines, building improvements, etc. They require tracking the assets by year purchased with costs including freight and installation, but not sales tax. No state income tax here, so they get it from you some other way.

When the spreadsheet got too complicated, I created the application to help me fill out their paper work and to learn a little about creating SQL tables.

At 11:36 AM 5/3/2005, Rob wrote:

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.

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.