× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. SYSTEM21
  3. July 2004

Re: Selecting a calculated date within a logical file.

I've done this before. I'm sure you can still do it - you need to update the 
DDS prior to creating the logical. It just needs a bit of fancy coding to look 
for the Select Statement within the DDS. 
  ----- Original Message ----- 
  From: Brunk, Kevin 
  To: System 21 Users 
  Sent: Friday, July 16, 2004 6:34 AM
  Subject: RE: [SYSTEM21] 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
  **********************************************************************


  _______________________________________________
  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 thread ...
Replies:
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.