Informix - uniqueidentifier

Posted in 2022

Summary

Dalia Hudson asked which Informix data type corresponds to SQL Server uniqueidentifier. Alexandre Marini pointed to the IBM documentation on the UUID utility, and Paul Watson offered a GUID UDR he had written. Dalia accepted the offer. No other answer was given.

Auto-generated by Claude from the posts below — may be imperfect; read the full thread.

Topics: Data Types & Schema Design

Dalia Hudson — source: IBM Community (ConnectedCommunity.org) Informix forum

Hi, In SQL Server they have - uniqueidentifier In Informix, what data type I should use ? Please help ------------------------------ Dalia Hudson ------------------------------ #Informix

↪ replying to Dalia Hudson

Alexandre Marini — source: IBM Community (ConnectedCommunity.org) Informix forum

Hello. Have you tried this way? https://www.ibm.com/docs/en/informix-servers/14.10?topic=SSGU8G_14.1.0/com.ibm.sqls.doc/ids_sqs_extend_chr_utility_uuid.html HTH Alexandre Marini

↪ replying to Alexandre Marini

Dalia Hudson — source: IBM Community (ConnectedCommunity.org) Informix forum

Hi Alexandre, Thanks ------------------------------ Dalia Hudson ------------------------------

↪ replying to Dalia Hudson

Paul Watson — source: IBM Community (ConnectedCommunity.org) Informix forum

I have a GUID UDR somewhere if you want it Cheers Paul Paul Watson Oninit LLC +1-913-387-7529 www.oninit.com Oninit® is a registered trademark of Oninit LLC

↪ replying to Paul Watson

Dalia Hudson — source: IBM Community (ConnectedCommunity.org) Informix forum

Hello Paul, Yes. Please share with me ------------------------------ Dalia Hudson ------------------------------