Interactive sort with API

[Guest.Visitor]

The method will depend on what type of subfile you are using, if you are loading the entire file, or just a page at a time. For the obvious sorts, or more common, you may be better off creating logicals, especially if it is a large file, and then reloading the subfile, using the logical for that sort/view. For other sorts, the API's you mentioned will work, closing the file, running OPNQRYF with Qcmdexc, and then reloading from the OPNQRYF, will also work.

[Guest.Visitor]

By clicking on column header I want to sort my subfile by that column. Don't want to create logicals because there are many columns in subfile and the file is not used elsewhere. Is there an another way to do that? Will QLGSORT/QLGSRTIO APIs do the work? If yes, where can I find code examples for T_H_E_S_E APIs (I have looked in lots of sites, redbooks and source examples - none of them gave examples for these particular APIs)? TIA for your time

[Guest.Visitor]

I had a SFLPAG=SFLSIZ sfl and created it with logicals (since I didn't find anything better). Thanks for the response.