Re: SQL Help

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