Hi Mathieu, Just a small comment: you are using UTF8 for storing UUID, on a VARCHAR. If this is just for testing functionality that’s OK. But for real production and high volume, if you want to optimize, please consider: CHAR(36) CHARACTER SET ISO88591 Trafodion would reserve 4 times more space for the key in UTF8 compared to ISO88591 plus 2 bytes for variable length of varchar that is not needed since UUID are always 36 char long. Hope this helps, Eric
From: mathieu ferlay [mailto:[email protected]] Sent: Thursday, March 16, 2017 2:46 AM To: [email protected] Subject: RE: issue with a request Thanks Benny. Best regard FERLAY Mathieu De : Wang, Ai-Min (Benny) [mailto:[email protected]] Envoyé : jeudi 16 mars 2017 08:42 À : [email protected]<mailto:[email protected]> 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：[email protected]<mailto:[email protected]> From: mathieu ferlay [mailto:[email protected]] Sent: Thursday, March 16, 2017 3:39 PM To: [email protected]<mailto:[email protected]> 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
