Original message
From: "Liu, Ming (Ming)" <ming@esgyn.cn>
Date: 03/14/2016 11:07 AM (GMT-06:00)
To: user@trafodion.incubator.apache.org
Subject: 答复: DDL column DEFAULT question
It works!
Thanks Anoop
发件人: anoop [mailto:anoop.sha...@esgyn.com]
发送时间:
It works!
Thanks Anoop
发件人: anoop [mailto:anoop.sha...@esgyn.com]
发送时间: 2016年3月15日 0:05
收件人: user@trafodion.incubator.apache.org
主题: RE: DDL column DEFAULT question
default date not null...
default comes before null clause. that
is ansi definition
anoop
Original message
default date not null...
default comes before null clause. thatis ansi definition
anoop Original message From: "Liu, Ming (Ming)"
<ming@esgyn.cn> Date: 3/14/2016 9:01 AM (GMT-08:00) To:
user@trafodion.incubator.apache.org Subject: DDL column DEFAULT que
Hi, all,
I need to create a table in Trafodion with columns having DEFAULT, but I cannot
make it work, any help will be very appreciated:
CREATE TABLE DBMARTA.ARPT_DIM_AUTORPT_PUB_MARK
(MARK_ID SMALLINTNOT NULL,
BEGIN_TIME DATENOT NULL DEFAULT date'2008-01-01',