creating a generated column in a create table statement

Database
Enthusiast

creating a generated column in a create table statement

I'm trying to convert my DB2 into Teradata..... hit a snag....

The last column of the table is a generated column (2 existing columns plus a hard-coded value)...

Is this possible?

Create multiset table test_db.table1(

data_month varchar(2),

data_year varchar(4),

col3 bigint,

col4 bigint,

data_date date ===(want to use data_year||'-'||data_month||'-01')

Any assistance is appreciated.

Thanks!

Rick

Tags (1)