If you live outside the United States, by submitting your email address you consent to having your personal data transferred to and processed in the United States.
SQL presents rows in the order that you tell it to present them. If you don’t tell it an order, the order will often be the physical order (but not guaranteed). If you want to see rows in a specific order, use SQL with an ORDER BY clause, or create a query with the order specified, or write a program. — Tom
DFU does allow viewing records in key order. The view is one record at a time though. You scroll through record by record. (In S/36 mode, DFU LIST might allow viewing a page of records at a time.) If DFU is not available, the UPDDTA command can do the same if record-by-record is acceptable. — Tom
SQL presents rows in the order that you tell it to present them. If you don’t tell it an order, the order will often be the physical order (but not guaranteed). If you want to see rows in a specific order, use SQL with an ORDER BY clause, or create a query with the order specified, or write a program. — Tom
DFU and some third party packages (ezview, dbu) allow viewing of “Logicals” based on logical keys
DFU does allow viewing records in key order. The view is one record at a time though. You scroll through record by record. (In S/36 mode, DFU LIST might allow viewing a page of records at a time.) If DFU is not available, the UPDDTA command can do the same if record-by-record is acceptable. — Tom
create WRKQRY and Select sort fields