RE: Identity Columns

[Dave Murvin <davem@xxxxxxxx>]

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.