Query output with duplicate column names eliminate subsequent data from output.
Reproduce able using
CSV:select ST.*,'~~~~~~~~~~',SP.TABLE_SCHEMA,SP.TABLE_NAME from QSYS2.SYSTABLES ST inner join QSYS2.SYSPARTITIONSTAT SP on ST.TABLE_SCHEMA = SP.TABLE_SCHEMA and ST.TABLE_NAME = SP.TABLE_NAME and ST.TABLE_SCHEMA = 'ILEDITOR
If you rename the disappearing column in the query it does show up.