Re: Identity column

[Alan Campin <alan0307d@xxxxxxxxx>]

Why are you using a decimal 5,0 field for an identity key? Should always be
an integer or big int.

On Mon, Nov 30, 2015 at 7:35 PM, Booth Martin <booth@xxxxxxxxxxxx> wrote:

> How do I retrieve a new record that I have just created?
>
> The file is created with a key:
>              NAID# decimal(5) not null       // ID#
>                    generated always as identity
>                    (start with 1),
>
> The scenario is this:
> -User keys the new data into blank fields on the screen, but of course not
> into the key field.
> -User presses Enter key.  Data is used to create a new record using
> embedded SQL
> -User wants to see the record on the screen, with the key field populated.
> -I can't figure out how to do that.
>
> --
> Booth Martin
> www.martinvt.com
> (802)461-5349
>
> Mr. Ranger isn't gonna like it, Yogi.
> --
> This is the RPG programming on the IBM i (AS/400 and 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.