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?
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: