topic Re: DB2 Varchar replicate to SQL table - not able to replicate all content - it takes up to a NULL value in Qlik Replicate

DB2 Varchar replicate to SQL table - not able to replicate all content - it takes up to a NULL value

ravirao68 — Thu, 26 Sep 2024 07:55:36 GMT

we have a DB2 table which has a VARCHAR(1800). This field stores different data values using COBOL copy structures. The data has EBCDIC Values. NULL values exist within the data values and the data is VALID.

The following is the Input & Output in the Table Settings (Transformation)

INPUT:

Name: VARDATA

Type: STRING

Character Set : IBM-37_P100-1995

OUTPUT:

Name: VARDATA

Type: STRING

Subtype: Regular

Expression: None

When we replicate this table, column VARDATA in the source endpoint is copied to target - data copied is only till the first NULL value and rest are not copied/replicated.

Is there a way for us to copy the entire VARCHAR 1800 bytes ASIS to the target.

Re: DB2 Varchar replicate to SQL table - not able to replicate all content - it takes up to a NULL value

john_wang — Thu, 26 Sep 2024 09:10:32 GMT

Hello @ravirao68 ,

Welcome to Qlik Community forum and thanks for reaching out here!

Would you please share the Replicate version and build number? eg Replicate 2023.11.0.282.

Thanks,

John.

Re: DB2 Varchar replicate to SQL table - not able to replicate all content - it takes up to a NULL value

ravirao68 — Thu, 26 Sep 2024 09:15:33 GMT

The Replicate Version is V2023.11.0.159.

Re: DB2 Varchar replicate to SQL table - not able to replicate all content - it takes up to a NULL value

ravirao68 — Thu, 26 Sep 2024 11:53:03 GMT

While checking in SSMS using SQL Query, I could see only till the NULL character. However, when I did BCP, I can see the whole data.

It is working as expected.

Sorry for the inconvenience caused.

Re: DB2 Varchar replicate to SQL table - not able to replicate all content - it takes up to a NULL value

john_wang — Thu, 26 Sep 2024 15:14:50 GMT

Thank you for your excellent support! @ravirao68