SQL index over field from another file

I would like to change some existing programs that use our A/R balance
(arbal) as an Input Primary file to now be sequenced by the customer
name which is in the Customer Master (custmast). I can accomplish this
with an OPNQRYF but would like to create an SQL index or view or
combination that I could change the program to use directly. My goal at
this point is to be able to just change the F spec in the program to a
different file name and recompile.



I have the following SQL statement which gives me the fields in file
arbal ordered by a field in file custmast.



select arbal.* from arbal left outer join custmast on abcustomer =
tucust order by tuname



I cannot figure out a way to get an index created that would present the
records in this order. Any ideas if this is possible?





Here is the OPNQRYF that accomplishes the task if that is useful:



OPNQRYF FILE((ARBAL) (CUSTMAST))

FORMAT(ARBAL)

KEYFLD((TUNAME))

JFLD((ARBAL/ABCUSTOMER CUSTMAST/TUCUST *EQ))

JORDER(*FILE)



Thanks,



Scott Mildenberger

Programmer/Analyst

Davis Transport Inc.

Missoula, MT

406-728-5510 x128