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

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 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.