Re: OPNQRYF to delete records using a position in the record as a selection criteria

Charles,

To get the name of the field use DSPFFD.

But the answer to your question is: no, it can't be done. You have to
process the file (with a shared OVRDBF) in a simple RPG programme, perhaps
using the logic cycle. The OPNQRYF should have DELETE options to allow the
deletes.

Regards,
Carel Teijgeler.

*********** REPLY SEPARATOR  ***********

On 5-10-2006 at 9:09 Charles St-Laurent wrote:

I would like to know if it is possible to delete records from a file with

the command OPNQRYF only if the first char of the record is equal to 'D'. I

don't know the name of the field at that position when I use the command

in my CLP... Something like:

If (%subst(Record:1:1) = 'D')
   Delete Record

directly in a OPNQRYF command...