|
Regardless of which approach, you will find it helpful to have an access path sorted by date to make the rebuild of the logical file (or SQL view/cursor) less painful. Especially if it is a large file (which most transactional files tend to be). Of all the approaches that I've heard so far, aesthetically I like the Join logical approach the best. But, you may run into some performance issues if this is a high volume file. Also, you can't update a join logical file. -Mike -----Original Message----- From: Rob Rogerson [mailto:rrogerson@xxxxxxxxxxxxxxxxx] Sent: Thursday, July 15, 2004 9:32 AM To: 'System 21 Users' Subject: RE: [SYSTEM21] Selecting a calculated date within a logical file. I suggested using OPNQRY based on Jon Wadey - 'What I am trying to achieve is to set-up a logical that will only pick-up the previous days transactions.' Since the previous day is always changing the selection criteria would be ever changing as well. Selection criteria in an OPNQRYF would accommodate this. Another solution would be to use SQL... Robert A. Rogerson -----Original Message----- From: system21-bounces@xxxxxxxxxxxx [mailto:system21-bounces@xxxxxxxxxxxx] On Behalf Of Brunk, Kevin Sent: Thursday, July 15, 2004 9:15 AM To: System 21 Users Subject: RE: [SYSTEM21] Selecting a calculated date within a logical file. Margaret, I'm not sure I understand your solution. There is no "select" parm on the CRTLF command. He'd have to write a program that would generate DDS source, that would accept the parm you suggest, and insert it into the source, then run the CRTLF command over this generated source. Rob's solution using OPNQRYF would work in concert with yours, since OPNQRYF allows the selection criteria to be specified in the command. But, if Jonathan is seeking a view that persists beyond the life of the CL program, he couldn't use OPNQRYF. ==Kevin -----Original Message----- From: system21-bounces+kbrunk=wabutler.com@xxxxxxxxxxxx [mailto:system21-bounces+kbrunk=wabutler.com@xxxxxxxxxxxx]On Behalf Of mslayton@xxxxxxxxxxx Sent: Thursday, July 15, 2004 8:49 AM To: System 21 Users Subject: Re: [SYSTEM21] Selecting a calculated date within a logical file. If you are going to use CL to set up and run this job, there is another way. You can create the logical file in the cl and pass it a parm for the select part of the logical file, and then delete the file when you get done with it. Thanks, Margaret "Jonathan Wadey" <Jon_Wadey@xxxxxxxxxxxxxxxxxx> Sent by: system21-bounces@xxxxxxxxxxxx 07/15/2004 07:08 AM Please respond to System 21 Users <system21@xxxxxxxxxxxx> To system21@xxxxxxxxxxxx cc Subject [SYSTEM21] Selecting a calculated date within a logical file. Dear All, Is it possible, and if so does anybody know how, to do a file selection on a date field within a logical file. What I am trying to achieve is to set-up a logical that will only pick-up the previous days transactions. TIA Jon Jon_Wadey@xxxxxxxxxxxxxxx _______________________________________________ This is the System 21 Users (SYSTEM21) mailing list To post a message email: SYSTEM21@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/system21 or email: SYSTEM21-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/system21. _______________________________________________ This is the System 21 Users (SYSTEM21) mailing list To post a message email: SYSTEM21@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/system21 or email: SYSTEM21-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/system21. ********************************************************************** CONFIDENTIALITY NOTICE: The information transmitted in this message is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and destroy all copies of this document. Thank you. The Butler Company ********************************************************************** _______________________________________________ This is the System 21 Users (SYSTEM21) mailing list To post a message email: SYSTEM21@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/system21 or email: SYSTEM21-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/system21. _______________________________________________ This is the System 21 Users (SYSTEM21) mailing list To post a message email: SYSTEM21@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/system21 or email: SYSTEM21-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/system21.
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.
midrange.com
