I am trying to write an ETL to populate the F41002 table running on an iSeries (AS/400) installation of JDE 8.9. My local staging environment is PostgreSQL on Ubuntu 14.0.4; my ETL tool is Pentaho PDI v5.01.
The schema for the F41002 lists the USTR field as CHAR (1); however, looking at...