I'm writing a program to process all the members in a physical file. I've done this using embedded SQL because the selection criteria is quite complex. The physical file belongs to an application which I can't change, so I will always have to deal with multiple members. I also don't have the possibility to build a logical file over the physical.
My problem is how can I process all the members as if they were all contained in one member? If I try using OVRDBF, then the embedded SQL doesn't work. To create an ALIAS for each member is a bit over the top, and I'd have to remove all the ALIAS's once my program is finished. The file is a bit on the large side to try copying everything into another file with one member (and it may have duplicate keys).
Anybody got any other ideas or suggestions?
Thanks in advance,