topic tAS400Row and BIGINT in Talend Studio

tAS400Row and BIGINT

Anonymous — Tue, 16 Jan 2018 17:56:51 GMT

When selecting the datatypes for my tAS400Output schema I'm unable to choose BIGINT as an option. Can't change the underlying database schema as it's pre-existing. Two questions:

1. Any thoughts on how I can resolve this? Is it a driver issue, or a Talend thing?

2. As a short term workaround I was considering a tFlowIterate and building a manual tAS400Row insert statement for each record (non-optimal, I know). Is there a better way to go about doing this?

Re: tAS400Row and BIGINT

vapukov — Wed, 17 Jan 2018 00:19:42 GMT

Yes, Talend - do not allow You to choose BIGINT

all depend - how Your components work?

if You do not create tables - You could choose long for Talend datatype and for example numeric for database type, Talend will mark this as warning, but not check when execute.

if You need create table - You can do this as separate tAS400row component and create any structure with plain SQL.

Also, You can edit Talend DataType Mapping (menu - File - Project Settings):

and after You will have new type available: