For years I’ve had trouble finding the correct Informix table (name) used by Sage Line 500’s Data Dictionary – until I discovered this nifty trick:
Note: Requires one to have Demo/Test company installed – accessing a database differently named to the live/production db. I work in a SuSE Linux Enterpise Server (SLES) environment.
1. Access the desired Sage screen/window. (e.g. if you’d like to know which table stores Sales Order Processing order detail – then go into any example order’s detail screen/window).
2. Open another session, log in as Infomix and run ‘onstat -g sql’. This will show all current database(s) threads. Most of these will (might) relate to the production db’s processes – so look for the process with the Demo/Test db’s name in it. Make a note of the process number (integer number on the left).
3. As Informix, run ‘onstat -g sql <process number>’ (e.g. ‘onstat -g sql 16342’) and look for the table name in the output (usually after ‘from’).
Let me know if problems!