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