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.