Distribute UNIQUEIDENTIFIER columns - connect_cdc_mimix_share - 5.8

Connect CDC System Reference Guide

Product type
Software
Portfolio
Integrate
Product family
Connect
Product
Connect > Connect CDC (MIMIX Share)
Version
5.8
Language
English
Product name
Connect CDC
Title
Connect CDC System Reference Guide
Copyright
2024
First publish date
2003
ft:lastEdition
2024-02-12
ft:lastPublication
2024-02-12T15:11:59.486869

The UNIQUEIDENTIFIER datatype is designed for storing system-generated, globally unique identifiers (GUIDs).

In Connect CDC hierarchical configurations, UNIQUEIDENTIFIER columns may be replicated or copied to MS SQL Server UNIQUEIDENTIFIER columns and to CHAR or VARCHAR columns or their equivalents in any Connect CDC target DBMS.

In bidirectional configurations, UNIQUEIDENTIFIER columns may be replicated or copied only to UNIQUEIDENTIFIER columns.

UNIQUEIDENTIFIER targets must have a UNIQUEIDENTIFIER source.

The UNIQUEIDENTIFIER values are stored in MS SQL Server databases in a 16-byte binary format, and Connect CDC reads and sends the values as hexadecimal-digit character strings (length 36) in the form:

xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx

where the 32 x’s are hex digits and the hyphens are included. For example:

6F9619FF-8B86-D011-B42D-00C04FC964FF

UNIQUEIDENTIFIER source columns may be distribution keys and may be part of an expression if the target column is a character type.

Note: The JDBC drivers always return a UNIQUEIDENTIFIER using lower case letters. You must compare to a constant that you define with lower case letters. The MS SQL Server SQL Query window returns them all in upper case.