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

Al Barsa wrote:

Hi,

My remembrance is that OPNQRYF only reports, and does not update/delete
data, but I could be wrong.

Al

Al Barsa, Jr.
Barsa Consulting Group, LLC

400>390

"i" comes before "p", "x" and "z"
e gads

Our system's had more names than Elizabeth Taylor!

914-251-1234
914-251-9406 fax

http://www.barsaconsulting.com
http://www.taatool.com
http://www.as400connection.com

"Charles St-Laurent" <dringpiece@hotma To il.com> midrange-l@xxxxxxxxxxxx Sent by: cc midrange-l-bounce s@xxxxxxxxxxxx Subject OPNQRYF to delete records using a position in the record as a 10/05/2006 09:10 selection criteria AM Please respond to Midrange Systems Technical Discussion <midrange-l@midra nge.com>

Hi!

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...

Thanks in advance for your answers
Charles



--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.