|
I am at a clients location without any manuals and have a qestion about OPNQRYF.
The save is running and I have a couple of hours to think about it. They are on
V3R6M0.
I have a three signed fields with decimal dates (6 0) in Julian Format. One is
from my OPNQRYF
selected file - field (Y$PDBA) and two are input by the user that are passed as
Parameters from
the CMD program to the CL program for the OPNQRYF (&BGDTJD - selected beginning
date and
&ENDTJD selected ending date). They were in *DATE fromat (CYMD) - but I
converted them to
Julian and then to a decimal 6 0 field to match the numeric Julian Date field in
the record that I am
running the OPNQRYF command on. Good old JDE Julian Dates!
In the OPNQRYF, I want to select records from a file using the date field Y$PDBA
if it falls between &BGDTJD and &ENDTJD).
I think the command should be something like this, but I can't remember it
exactly and I am not
sure of the form.
OPNQRYF FILE((*LIBL/F0619)) QRYSLT ('Y$PDBA = %RANGE (&BGDTJD &ENDTJD)')
Is this correct? Any help would be appreciated.
Thanks,
Bill Briggs
Logical Designs, Inc.
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* This is the Midrange System Mailing List! To submit a new message, *
* send your mail to "MIDRANGE-L@midrange.com". To unsubscribe from *
* this list send email to MAJORDOMO@midrange.com and specify *
* 'unsubscribe MIDRANGE-L' in the body of your message. Questions *
* should be directed to the list owner / operator: david@midrange.com *
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.