JamieCairns
Programmer
I need to create an ODBC link to some shipping software, and have to use the data from 4 or 5 different physical files on the 400. I also have to update several of the fields - possibly in more than one PF.
My idea is to create an LF Join file on the 400 rather than a complicated SQL statement on the PC, so that the SQL from the external s/w is as simple and as quick to run as possible.
Any holes in my thinking ?
If not, anyone willing to give me a lesson in creating Join LF's ?
Oh yeah - we're using a dinosaur 400 - V4R5.
Jamie
My idea is to create an LF Join file on the 400 rather than a complicated SQL statement on the PC, so that the SQL from the external s/w is as simple and as quick to run as possible.
Any holes in my thinking ?
If not, anyone willing to give me a lesson in creating Join LF's ?
Oh yeah - we're using a dinosaur 400 - V4R5.
Jamie