Re: SQL Help

[Charles Wilt <charles.wilt@xxxxxxxxx>]

Doesn't appear to be supported by DB2 for i...

You could add a before insert trigger to the table to update the row as it
was added...

Why use a sequence?  The only reason for a sequence would be for a value
shared between tables...

Why not just leave it as an identity?

Charles

On Tue, Apr 9, 2019 at 2:52 PM Cyndi Bradberry <CyndiB@xxxxxxxx> wrote:

> We are trying to translate the following MS/SQL statement into one that
> will work on iSeries.
>
> ALTER TABLE [HOLLIB].[WEBACH] ADD  CONSTRAINT [DF_WEBACH_AC900]  DEFAULT
> (NEXT VALUE FOR [HOLLIB].[WEBACH_AC900_ODD]) FOR [AC900]
>
> Our goal is to replace an identity column with a sequence. We are feeding
> the same table from both RPG/Green Screen and SQL inserts from the web.
>
> Any suggestions ?
>
> ALTER TABLE HOLLIB/WEBACH ALTER COLUMN AC900 SET DATA TYPE BIGINT
> WITH DEFAULT hollib/webac00001
>
> We got to this point, but still no joy. The HOLLIB/WEBAC00001 is a data
> area that was created by SQL and it holds the sequence.
>
> TIA,
>
> Cyndi
> Boise, ID
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: https://amazon.midrange.com