topic Re: Data Extraction from AS400 in Talend Studio

Data Extraction from AS400

Anonymous — Sat, 16 Nov 2024 07:51:21 GMT

Hi Team,

I am trying to extract data from AS400 db through TOS version 7.

The data present in db having CCSID code as 65535 and in HEXADECIMAL format.

Can anyone please suggest how to change CCSID code from Talend end so that proper data can be loaded to target.

Target is MySQL.

Any help is highly appreciated.

Thanks & Regards,

Nabarun

Anonymous — Mon, 06 Aug 2018 18:55:35 GMT

Hi,

Please read the hexadecimal value as a string and in the tmap, use the below expression.

Integer.parseInt("65535",16) -> replace hard coded value with column from tinput component inside tmap.

The above value was changed to 41509 after converting to integer.

Warm Regards,

Nikhil Thampi

Anonymous — Tue, 07 Aug 2018 05:16:57 GMT

Hi Nikhl,

Thanks for replying.

But the way you suggested is to convert 65535 to integer.

But 65535 is not a value. It is the CCSID code which is used to encode the data in AS400 db.

Sample input and needed output is mentioned below.

Input: D9E3

Output: RT

The mentioned input is the data present in AS400, and the mentioned output is the data should be loaded for the same input in MySQL.