kbens

Local Record &rRecord = CreateRecord(Record.RECORD);
Local SQL &SQL = CreateSQL("SELECT * FROM PS_RECORD");

While &SQL.Fetch(&rRecord)
   /**/
End-While;

kbens

/* Process Sched Parameters */
SELECT prcsinstance,
       prcsfilename
FROM   psprcsparms
ORDER  BY prcsinstance DESC