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

[ravirao68]

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.  

[john_wang]

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.

[ravirao68]

The Replicate Version is V2023.11.0.159.

[ravirao68 · Accepted solution]

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.

[john_wang]

Thank you for your excellent support! @ravirao68