Re: SQL Help

[Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>]

Hi Cyndi

Even though SQL created the data area, you can't use it directly in an 
SQL statement like this - it's not a database object.

I'm not sure, but there might be some SQL statement that retrieves the 
value of a SEQUENCE - that IS a database "thing-a-ma-bob" and can 
probably be used.

HTH
Vern

On 4/9/2019 3:52 PM, Cyndi Bradberry 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