RE: issue with a request

[mathieu ferlay]

Thanks Benny.

 

Best regard

 

FERLAY Mathieu

 

 

De : Wang, Ai-Min (Benny) [mailto:aimin.w...@esgyn.cn] 
Envoyé : jeudi 16 mars 2017 08:42
À : user@trafodion.incubator.apache.org
Objet : RE: issue with a request

 

Hi:

 

Pleaes use following sql， UUID  is reserved word and please use “” to enclose 
it：

 

CREATE TABLE IF NOT EXISTS Token (

  "UUID" VARCHAR(36) CHARACTER SET utf8 COLLATE DEFAULT NOT NULL,

  Expiration DATE NOT NULL,

  SOPInstanceUUID VARCHAR(64) CHARACTER SET utf8 COLLATE DEFAULT NOT NULL,

  PRIMARY KEY ("UUID")

);

 

 

Best Regrard！

 

Benny/Wang Aimin

MP：13501196050

Mail：aimin.w...@esgyn.cn <mailto:aimin.w...@esgyn.cn> 

 

From: mathieu ferlay [mailto:mfer...@gnubila.fr] 
Sent: Thursday, March 16, 2017 3:39 PM
To: user@trafodion.incubator.apache.org 
<mailto:user@trafodion.incubator.apache.org> 
Subject: issue with a request

 

Hi everybody, i try to load these following lines:

 

CREATE TABLE IF NOT EXISTS Token (

  UUID VARCHAR(36) CHARACTER SET utf8 COLLATE DEFAULT NOT NULL,

  Expiration DATE NOT NULL,

  SOPInstanceUUID VARCHAR(64) CHARACTER SET utf8 COLLATE DEFAULT NOT NULL,

  PRIMARY KEY (UUID)

);

 

But I obtain systematically a mistake on UUID. Do you know how to success it 
with this column’s name?

 

Thanks,

Regards

 

FERLAY Mathieu