latest trafodion code that will be part of traf 2.3 will generate a 36 byte 
unique id
in string format.

      Apache Trafodion Conversational Interface 2.3.0
      Copyright (c) 2015-2017 Apache Software Foundation
      >>select unique_id() from dual;



      --- 1 row(s) selected.

Prior code was generating a binary representation which will display as 
unprintable characters.
One can use converttohex function on top of it to convert it to hex 

Ming may have further comments.


-----Original Message-----
From: Liu, Yuan (Yuan) <>
Sent: Friday, March 9, 2018 6:40 PM
Subject: unique_id() not documented and get messy code

Hi Trafodioneers,

It seems we support unique_id() but not documented.
I just tried it in trafci and get messy code.
SQL>select unique_id() from dual;


--- 1 row(s) selected.

Is there something wrong?

Best regards,

Reply via email to