Focal Point
[SOLVED] Uniqueidentifier Column in SQL comes with braces in Data Migrator Synonyms

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/1381057331/m/6047091286

May 05, 2016, 11:58 AM
Virul Patel
[SOLVED] Uniqueidentifier Column in SQL comes with braces in Data Migrator Synonyms
Hi,

I have table in SQL Server that has column with data type Uniqueidentifier.

I created synonym in data migrator for same table, data type is A38 Fixed. But when I see values that values included {}.

In SQL : 72951DA9-B1B6-E411-8C7F-0050560E00AE
IN DM Synonym : {72951DA9-B1B6-E411-8C7F-0050560E00AE}

Any idea ?
How to remove {} from DM Synonym.

Thanks,

This message has been edited. Last edited by: Tamra,


Virul Patel
Product :
iWay Data Migrator (8.1)
WebFocus 8.1
SQL SERVER 2012
May 10, 2016, 04:31 PM
Clif
This has been addressed in 8.2 through the use of the new MS ODBC driver.

However for the nonce you can create a DEFINE in the synonym
XID/A36=SUBSTRING(UID,2,36)

May 11, 2016, 09:09 AM
Virul Patel
Thank You, Cliff


Virul Patel
Product :
iWay Data Migrator (8.1)
WebFocus 8.1
SQL SERVER 2012