I have an ODBC file linked as the primary source for a Query. Using a field from that file, I want to retrieve data from a PxPlus file on our server. I don't see how PxPlus will let me do this. It seems that once the primary is set as external, it expects all files to be in the same external Database; no "mix-and-match" capabilities.
Did I miss something?
You can use the Database Import Utility in Data Dictionary Maintenance to import the data dictionary information from your external table into the dictionary files. Once there, the table can be selected in the query from the regular list of table names, and you can mix and match external and native files.