MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » May 1999

Re: Date Validation File



fixed

Chris,

Do you happen to have Advanced Systems Concepts (ASC) Sequel product?  It
has program (SQDATE) that will build a date file (SQDATE) similar to what
you are looking for. Here is the fields in the file for info.

MMDEC            2     2       0         P      Month         Dec(2,0)
DDDEC            2     2       0         P      Day           Dec(2,0)
YYDEC            2     2       0         P      Year          Dec(2,0)
CDEC             1     1       0         P      Century code  Dec(1,0)
MMCHR            2     0       0         A      Month         Char(2)
DDCHR            2     0       0         A      Day           Char(2)
YYCHR            2     0       0         A      Year          Char(2)
CCHR             1     0       0         A      Century code  Char(1)
MDYDEC           4     6       0         P      MMDDYY date   Dec(6,0)
DMYDEC           4     6       0         P      DDMMYY date   Dec(6,0)
YMDDEC           4     6       0         P      YYMMDD date   Dec(6,0)
MDYCHR           6     0       0         A      MMDDYY date   Char(6)
DMYCHR           6     0       0         A      DDMMYY date   Char(6)
YMDCHR           6     0       0         A      YYMMDD date   Char(6)
YYJULD           3     5       0         P      YYDDD  date   Dec(5,0)
YYJULC           5     0       0         A      YYDDD  date   Char(5)
DAY              9     0       0         A      Day of week
DAYSHT           3     0       0         A      Abbreviated day of week
MONTH            9     0       0         A      Month
MTHSHT           3     0       0         A      Abbreviated month
LNGDTU          18     0       0         A      Long date - month day, year
LNGDTE          18     0       0         A      Long date - day month year
FULLYR           3     4       0         P      Year (with century)
JUL1             3     5       0         P      Day offset from 1 Jan 1901
JUL2             2     3       0         P      Day offset from 1 Jan
current


Kevin Watkins
Sun Industries, Inc.
kevinw@hurtcompanies.com

----- Original Message -----
From: <>
To: <midrange-l@midrange.com>
Sent: Wednesday, May 19, 1999 6:47 AM
Subject: Date Validation File


Hi y'all,

I'm constructing a date validation routine using a date file rather than
inspecting the date value.

Although it is quite easy to formulate a date file showing YYYYMMDD, Day of
Week, Julian date etc. it is a rather different ball game ascertaining
whether
the date was or will be a Public Holiday.

So my question is ......... are there date files commercially available out
there or or they easily retreivable from certain applications or does one
exist
within OS400?

kr

Chris


+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator:
david@midrange.com
+---

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---






Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot 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 here. If you have questions about this, please contact