Creating a century window in QUIZ/QTP for PROMPT variables.
Neil Harvey
neil@nha.co.za
Thu, 2 Apr 1998 20:08:27 +0200
Nice work, Roger.
Isn't it a great feeling to have added the century to every date in the
system?
I worry a lot about the people who are looking for quick and dirty
fixes, like planning to use the existing 6 position date fields to buy
them time until 2027, or whenever.
I say do it right, and do it now.
Maybe while we're at it, we should make the date field 10 positions. A
pig on storage, but the folks in 99991231 will love us, and the folks in
999991231 will REALLY thank us :)
Again, congratulations on a stirling effort.
Regards
Neil
> -----Original Message-----
> From: Marcinik, Roger [SMTP:MARCINIR@pgocm3.ksc.nasa.gov]
> Sent: Thursday, April 02, 1998 7:20 PM
> To: 'Blair Combs'; Deskin, Bob
> Cc: powerh-l@lists.swau.edu
> Subject: RE: Creating a century window in QUIZ/QTP for PROMPT
> variables.
>
> The Boeing Company policy here at KSC is to have all dates converted
> to 8
> characters on the HP3000.
> They are far along in this process and have only 2 more databases with
> 67
> datasets to go. These will be done by December this year. After
> that,
> there will be no more 6 character dates in the dictionary or files
> here.
>
> > -----Original Message-----
> > From: Blair Combs [SMTP:combblai@isu.edu]
> > Sent: Thursday, April 02, 1998 11:50 AM
> > To: Deskin, Bob
> > Cc: powerh-l@lists.swau.edu
> > Subject: Re: Creating a century window in QUIZ/QTP for PROMPT
> > variables.
> >
> > There is one item I thought should be mentioned here for the
> > benefit of the MPE/iX community at least. There are still
> > date related problems in version 7.29.C8 that Cognos seems
> > to be taking lightly that will create serious problems for
> > us and probably others.
> >
> > As you go through your systems converting dates you will
> > normally have a period of time when you will have some 8
> > digit dates as well as 6 digit dates utilized within the
> > same dictionary. I believe this to be very common. In this
> > situation, if your SYSTEM OPTIONS specify CENTURY EXCLUDED,
> > the SYSDATE variable will be incompatible with 8 digit dates
> > included in your dictionary. Consequently, the use of the
> > ADDCENTURY is required to convert the SYSDATE when working
> > with an 8 digit date. ADDCENTURY will be required whenever
> > you are working with two incompatible dates, one 8 digits
> > and the other 6 digits.
> >
> > We were all promised that the ADDCENTURY function would be
> > enhanced in version 7.29.C8 for MPE/iX to recognize a date
> > already includes the century and not attempt to add the
> > century again in this case. We have been in the date
> > conversion process now for two years with the expectation of
> > this feature being available with this release. All our
> > reprogramming has been along these lines. Now we are being
> > told, "Sorry, we are not enhancing 7.29 any longer and you
> > will have to wait for version 8.19 which should have this
> > feature working correctly."
> >
> > With the full release of 8.19 still months away Cognos is
> > putting their MPE/iX customers (or are we the only ones) in
> > a very difficult position.
> > Are we going to be forced into beta testing 8.19 with our
> > production systems because Cognos did not keep their promise
> > and are unwilling to correct the situation?
> >
> > I would really appreciate a response from Cognos on these
> > concerns posted here.
> >
> > TIA,
> >
> > Blair Combs
> > Idaho State University
> >
> > *********************
> >
> > Deskin, Bob wrote:
> >
> > << snip >>
> >
> > > The complaint versions (with the problems fixed) are:
> > >
> > > PowerHouse series 7
> > > MPE/iX - 7.29.C8 and up
> > > OpenVMS - 7.10.F2 and up
> > > UNIX - 7.33.D3 and up, except for DG Intel which is 7.33.E2 and up
> > >
> > > PowerHouse series 8
> > > MPE/iX - 8.09.C and up
> > > OpenVMS - 8.00.C1 and up
> > > UNIX - 8.03.C1 and up
> > > NT - 8.01.C1 and up
> > >
> > > Any appropriately supported customer can get the compliant
> versions
> > > free of charge. Contact Customer Support or Cognos Direct.
> > >
> > > Bob Deskin
> > > ---------- << File: Card for Combs, Blair >>
> = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> = = =
> Subscribe: "subscribe powerh-l" in message body to
> majordomo@lists.swau.edu
> Unsubscribe: "unsubscribe powerh-l" in message to
> majordomo@lists.swau.edu
> powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
> This list is closed, thus to post to the list, you must be a
> subscriber.
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
This list is closed, thus to post to the list, you must be a subscriber.