Non-DDS files actually has a filename for the whole record. Find your file's fieldname using this command, which uses query/400:
runqry *n mylib/myfile
The fieldname to use in your query will be the heading-name (propably F00001..).
Now create your query making a resultfield : enter a resultfieldname, fx COMPCOD, and enter this expression
substr(F00001, 925, 3)
Then enter some selection in your query, and VOILA.... :-)
I hope thisworks for you
I’m not sure if query will work with a file that long
However, you would make a result field using substr to get the company
Then use the result field in the select record option.
But you say Company Code ’01′ which is the 925-927 — 925-927 is three characters wide?