SQL Help

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