My client has a table on their IBMi with a foreign key to another table. It's not showing up with a
SELECT * FROM lib.table. However, if I specifically mention it in the column list. It does show up.
SELECT col1, col2.col3, fxcolid FROM lib.table
I'm using the jt400 driver to query from SQLWorkbench/J.