RE: 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
**********************************************************************