openqryf question

I haven't worked much with OPENQRYF. Is there a good on-line source
that would have some examples I could follow that you could give me a
link to?

I have a physical file that contains the date in two separate fields
both defined as numeric.:

PFYR = YYYY
PFMD = MMDD

Both of these fields are defined as numeric.

I would like to use OPENQRYF to select a range of records on the fly
which includes certain dates.

How do I do this in a QRYSLT statement? Do I need to first create a
concatenated field of PFYR & PFMD into DATEYYMD and then do a range
like select like:
'QRYSLT('DATEYYMD * EQ %RANGE("19990101" "20051231") ')

Do I need the quotes around the two dates? How do I create the
DATEYYMD - can I do that in the OPENQRYF somehow or do I have to
create a CL program to do all of this? I'm not sure what the
ramifications are with the dates in the PF being numeric and maybe for
the qryslt statement they need to be character?

thanks,
ga


ga
nospam.RemoveThis@nospam.fmctc.com