I've written a very simple SQL statement on system I navigator and it shows all I need, but this statement cannot work any platform except system i navigator. When I tried to connect as400/IBM I on Excel, it does successfully connect. But the schemas and tables contain nonsense information.
My SQL statement is:
SELECT * FROM CAPPSERV.XRFFIL02.PRDMST01
I can't even find the XRFFIL02 in Excel.
I've found this "AS400 and System I Navigator" and tried to find my SQL name, but it shows my file name and SQL name are the same.
Maybe my direction was wrong.