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;
(EXPR)
------------------------------------
b2d1426c-4459-4464-b733-8de9aa1e84ea
--- 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
representation.
Ming may have further comments.
anoop
-----Original Message-----
From: Liu, Yuan (Yuan) <[email protected]>
Sent: Friday, March 9, 2018 6:40 PM
To: [email protected]
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;
(EXPR)
----------------
v聦聢掳f脩T
--- 1 row(s) selected.
Is there something wrong?
Best regards,
Yuan
