topic Re: Data type mismatch in Talend Studio

Data type mismatch

rwnetwork — Sat, 07 Dec 2019 18:24:27 GMT

Hi there,

It's my 1st time writing to an idb2(as400) table that is already created. I'm getting a data type mismatch error.

Please, are there any suggestions on how to narrow down the field with the data type mismatch? I've attempted several new data types in several fields, but I am unable to narrow it down.

Thank you!

Attached is the workflow, idb2 schema and the input schema.

Re: Data type mismatch

Anonymous — Sun, 08 Dec 2019 12:18:00 GMT

Hi,

Unfortunately, I do not have this DB handy to test it myself. But from first glance, I could see some data type mismatch. For example, you are trying to load date value to a numeric field as shown below.

Could you please make necessary corrections and try it out?

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved

Re: Data type mismatch

rwnetwork — Mon, 09 Dec 2019 14:40:29 GMT

Oh geez, I didn't even see those 2 mismatches. Yes, let me see if that works.

Thank you!

Re: Data type mismatch

rwnetwork — Mon, 09 Dec 2019 17:54:52 GMT

Ok as of now it appears I fixed the 'Data type mismatch'.

I used the java expression attached and have not received the error again. (QuoteDate_SurveyDate_java_integer.png)

HOWEVER, now I have a new error and my attempted solution is not working. I think it has to do with the literal null values that are coming through. I have NULL values coming through my input for 3 different columns. (3_NULL_Columns.png)

The idb2 table I am writing to for these 3 columns is this: (3_NULL_Columns_idb2datatypes.png)

The errors I'm getting are this, using my attempted solution.

(ForInputstring_NULL.png)

(Null_Special_Term.png)

Suggestions?

Thank you in advance for any help.

Michelle

Null_Special_Term.png
ForInputstring_NULL.png
3_NULL_Columns_idb2datatypes.png
QuoteDate_SurveyDate_java_integer.png

Re: Data type mismatch

rwnetwork — Mon, 09 Dec 2019 18:25:29 GMT

I MAY have corrected this by using the following expressions in the 2 date fields:

But now I have a new error, so I'm going to accept this as a solution for now on this post, then post a new conversation.

Thank you!

QuoteDate_SurveyDate_java_integer.png