Hi

Can I convert a plain integer column (non-key) in a table to a generated
column using the ALTER TABLE .. ALTER COLUMN statement?

If not, should I use the ALTOBJ statement?

-R-

Jurgen Haan wrote:[color=blue]
> Hi
>
> Can I convert a plain integer column (non-key) in a table to a generated
> column using the ALTER TABLE .. ALTER COLUMN statement?
>
> If not, should I use the ALTOBJ statement?
>
> -R-[/color]
Direct mit ALTER TABLE. Neu in V8.2

--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab

Serge Rielau wrote:[color=blue]
> Jurgen Haan wrote:
>[color=green]
>> Hi
>>
>> Can I convert a plain integer column (non-key) in a table to a
>> generated column using the ALTER TABLE .. ALTER COLUMN statement?
>>
>> If not, should I use the ALTOBJ statement?
>>
>> -R-[/color]
>
> Direct mit ALTER TABLE. Neu in V8.2
>[/color]

Ah. Vielen dank.

I'm not German though (dutch) :P
(I DO understand the language)

-R-

Okay... I've defined a small test setup:
Created the following table
test (
bla1 integer,
bla2 integer,
);

inserted the following values: ((0,0),(0,1),(1,0),(1,1))

then I used the following statements:

set integrity for test off;
alter table test alter column BLA2 set generated always as (BLA1+2);
set integrity for test immediate checked force generated;

resulting in:

BLA1 BLA2
----------- -----------
0 2
0 2
1 3
1 3

Works like a charm :)

-R-