topic Equvalent data type for nvarchar in tDBOutput for DB2 database in Talend Studio

Equvalent data type for nvarchar in tDBOutput for DB2 database

ganeshK — Tue, 07 Sep 2021 11:16:43 GMT

Hi,

I am reading file input and insert into DB2 database table. One scenario i got input is lie below and received error in talend job tDBOutput component.

DB2 SQL error: SQLCODE: -302, SQLSTATE: 22001, SQLERRMC: null

[ERROR]: Project.X_l_subjob_0_1.X_L_Subjob - tDBOutput_1 - DB2 SQL error: SQLCODE: -302, SQLSTATE: 22001, SQLERRMC: null

DB2 table column datatype - char(20)

Input Type - String

tDBOutput - Type - String , DB Type - varchar

File input value - 00625ä¸€1020504äºº0325

Re: Equvalent data type for nvarchar in tDBOutput for DB2 database

XJ_1630 — Tue, 07 Sep 2021 11:57:35 GMT

Hi @not specified not specified

It seems that:

your target DB2 columns is a CHAR(20)
your input string has 23 characters

trim your string, or increase the size of column

another point to have in mind: values in a DB2 char() will be PADDED with spaces to the full length, if they are shorter than 20 chars in length

Re: Equvalent data type for nvarchar in tDBOutput for DB2 database

ganeshK — Wed, 08 Sep 2021 04:30:33 GMT

Hi,

I am already doing Stringhandling.left(InputValue,20)

Main problem is the special characters in input value, looks some messy values. It is not working with varchar in tDBOutput component.

tDBOutput - Type - String , DB Type - varchar

File input value - 00625ä¸€1020504äºº0325

tLogRow output after trim -> 00625Ã€ÂžÂ€1020504Ã€

Re: Equvalent data type for nvarchar in tDBOutput for DB2 database

Anonymous — Wed, 08 Sep 2021 06:50:02 GMT

What encoding do you use to read the value from input file? By default, it is 'ISO-8859-15', have a try to change it to UTF-8 or other type that matches the string encoding. This properties is located in the advanced settings panel of tFileInputXXX component.

Regards

Shong