Date problems with years over 2040 in tAS400input

Highlighted
Five Stars

Date problems with years over 2040 in tAS400input

Hi,

 

I am trying to select dates using a tAS400input component in Talend 6.3.

 

In some of these dates, years are over 2040, and they are considered null in the result panel of sql builder of the component.

For example, date '2039-12-31' is fine, but date '2040-01-01' isn't:

pb date.png

 

I don't have the problem using System i Navigator for example:

pb date_iSeries.png

 

Any idea of what can cause the problem?

 

Thank you in advance for your help!

 

 

 

 


Accepted Solutions
Five Stars

Re: Date problems with years over 2040 in tAS400input

Hi Sabrina,

I'm using date format "dd-MM-yyyy" in Talend.

I don't have problems reading other dates, my AS400 table have more than 100000 lines and dates over 2040 represent 20 lines only.

I managed to resolved the problem by casting the date as timestamp...

Regards,

Alice

 


All Replies
Moderator

Re: Date problems with years over 2040 in tAS400input

Hello,

What's the date type are you setting in talend studio? Not sure the date is read correct from the source database, try to add a tLogRow after tAs400Input to print the date on the console.

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Five Stars

Re: Date problems with years over 2040 in tAS400input

Hi Sabrina,

I'm using date format "dd-MM-yyyy" in Talend.

I don't have problems reading other dates, my AS400 table have more than 100000 lines and dates over 2040 represent 20 lines only.

I managed to resolved the problem by casting the date as timestamp...

Regards,

Alice

 

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

6 Ways to Start Utilizing Machine Learning with Amazon We Services and Talend

Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend

Blog