RE: 答复: DDL column DEFAULT question

2016-03-14 Thread Rohit
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] 发送时间:

答复: DDL column DEFAULT question

2016-03-14 Thread Liu, Ming (Ming)
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

RE: DDL column DEFAULT question

2016-03-14 Thread anoop
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

DDL column DEFAULT question

2016-03-14 Thread Liu, Ming (Ming)
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',