Stack Exchange network consists of 183 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
Visit Stack Exchange
Stack Internal
Knowledge at work
Bring the best of human thought and AI automation together at your work.
Explore Stack Internal My client has a table on their IBM iIBMi 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.
My client has a table on their IBM i 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.
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.
My client has a table on their IBM i 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.