Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guru. There are 2 Sources MS SQL Server and Postgres and one Target - Sybase IQ
For column with CLOB datatype (varchar (max) for MS SQL and text for Postgres) there is datatype conversion from CLOB to String (1000) without any transformation functions on it. See screenshot
For Postgres values for CLOB columns replicates well in both modes FullLoad and ChangeProcessing
But for MSSQL CLOB columns loaded well in FullLoad mode, but in ChangeProcessing any changes CLOB column leads to replicating empty string on the Target.
In which way is it possible replicate CLOB to Varchar for MS SQL server in change processing mode?
Hello,
It is a limit of replicate that it can not perform string functions on a CLOB field.
This article will describe a work around that will allow the CLOB string function that you want to work by using a source lookup function to get the value and then that is wrapped by the string function you want to perform.
Please check out;
Transformation - CLOB - string functions
https://community.qlik.com/t5/Official-Support-Articles/Transformation-Source-Lookup-CLOB-datatype-l...
Please let me know if this helps out.
Thanks,
Michael
Hello,
It is a limit of replicate that it can not perform string functions on a CLOB field.
This article will describe a work around that will allow the CLOB string function that you want to work by using a source lookup function to get the value and then that is wrapped by the string function you want to perform.
Please check out;
Transformation - CLOB - string functions
https://community.qlik.com/t5/Official-Support-Articles/Transformation-Source-Lookup-CLOB-datatype-l...
Please let me know if this helps out.
Thanks,
Michael
Hi Michael,
I know that attempt to use function on LOB column leads to NULL value on the Targer. But in our case we don't use string functions on a CLOB field. We just changed datatype from CLOB to STRING. And in that case, this is a fully working solution for Postgres replication, but for MS SQL it leads to empy string (not null) while ChangeProcessing mode is using
Hello,
That makes sense, I missed the part of your comment where you mentioned that there are no transformations.
I will look into this and reply back with my findings.
Thanks,
Michael