RE: Selecting a calculated date within a logical file.

Margaret,

Maybe there was a different version of OS/400 in the UK at one time that 
allowed this, but I've never seen a feature like this - as nice as it would 
have been.  I did however, work with a third party command at one time, CRTLV 
(Create Logical View) and it allowed precisely what you describe.  It was very 
nice and sadly it became supported by (whomever wrote it) as OS/400 marched on. 

==Kevin

-----Original Message-----
From: system21-bounces@xxxxxxxxxxxx
[mailto:system21-bounces@xxxxxxxxxxxx]On Behalf Of mslayton@xxxxxxxxxxx
Sent: Thursday, July 15, 2004 12:03 PM
To: System 21 Users
Subject: RE: [SYSTEM21] Selecting a calculated date within a logical
file.


Yes,   it would need to be deleted and recreated each time the date 
changed.   You could accomplish this by deleting the logical before 
midnight and recreate it using todays date.  It would then be set for the next 
day.  We created the logical in a cl and passed a parm for the new 
date every time we ran the cl.  We deleted the logical in the cl right 
before we re-created it.   You can pass a parm to the create logical.  I 
forget how we did it.    Margaret 



"Rob Rogerson" <rrogerson@xxxxxxxxxxxxxxxxx> 
Sent by: system21-bounces@xxxxxxxxxxxx
07/15/2004 11:44 AM
Please respond to
System 21 Users <system21@xxxxxxxxxxxx>


To
"'System 21 Users'" <system21@xxxxxxxxxxxx>
cc

Subject
RE: [SYSTEM21]   Selecting a calculated date within a logical file.






I'm pretty sure this solution would require the logical to be created
each time the date was changed.  There still is select/omit but it is
static.  If you changed this value each time and recreated the logical
with the new select/omit criteria this would work.

Robert A. Rogerson

-----Original Message-----
From: system21-bounces@xxxxxxxxxxxx
[mailto:system21-bounces@xxxxxxxxxxxx] On Behalf Of mslayton@xxxxxxxxxxx
Sent: Thursday, July 15, 2004 11:40 AM
To: System 21 Users
Subject: RE: [SYSTEM21] Selecting a calculated date within a logical
file.

There used to be a select function in the dds for select/omit.  That is
what I am talking about.  Years ago we would create a logical file in a
cl
and pass it a parm to populate the select part of the dds.  I don't have

access to how I did it but I can remember doing it. Margaret



"Brunk, Kevin" <KBrunk@xxxxxxxxxxxx>
Sent by: system21-bounces@xxxxxxxxxxxx
07/15/2004 09:15 AM
Please respond to
System 21 Users <system21@xxxxxxxxxxxx>


To
"System 21 Users" <system21@xxxxxxxxxxxx>
cc

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.

_______________________________________________
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
**********************************************************************