Hi, im testing a connector to IBM DB2 and would li...
# advice-data-ingestionc
Cristian Ivanoff
09/13/2022, 1:46 PMHi, im testing a connector to IBM DB2 and would like to set a parameter on the connector: -Ddb2.jcc.charsetDecoderEncoder=3
Is this possible?
Cristian Ivanoff
09/13/2022, 4:31 PM@Yurii Bidiuk [GL]
Cristian Ivanoff
09/13/2022, 4:33 PMIm getting an error. I found how to resolve the problem but dont know how to apply this. https://www.ibm.com/support/pages/sqlexception-message-caught-javaiocharconversionexception-and-errorcode-4220
y
Yurii Bidiuk [GL]
09/13/2022, 4:43 PMHi @Cristian Ivanoff
Please try to use Custom JDBC properties field for this property. It's available in the latest version or connector
c
Cristian Ivanoff
09/13/2022, 5:05 PMThanks for replying @Yurii Bidiuk [GL] but I cant get it to work. I im using the latest and adding this:
Cristian Ivanoff
09/13/2022, 5:11 PMI have also tried this “db2.jcc.charsetDecoderEncoder=3”
Cristian Ivanoff
09/20/2022, 3:11 PM@Yurii Bidiuk [GL] another problem that I get is that when an error occurs in the sync it will begin from start again. So if I already loaded lets say 10M rows of 20M it will re-sync everything again after I remove the row where the problem exists due to the charset problem.