Creating a century window in QUIZ/QTP for PROMPT variables.

Blair Combs combblai@isu.edu
Thu, 02 Apr 1998 09:50:11 -0700


This is a multi-part message in MIME format.
--------------1BD8989A0AA5ADDEC50D057E
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

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
> ----------
--------------1BD8989A0AA5ADDEC50D057E
Content-Type: text/x-vcard; charset=us-ascii; name="vcard.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Card for Combs, Blair
Content-Disposition: attachment; filename="vcard.vcf"

begin:          vcard
fn:             Blair Combs
n:              Combs;Blair
org:            ISU Computing and Communications
adr:            890 South 5th Ave;;Computer Center, Box 8037;Pocatello;Idaho;83209;USA
email;internet: combblai@isu.edu
title:          DP Manager of Administrative Systems
tel;work:       208.236.2399
tel;fax:        208.236.3673
x-mozilla-cpt:  ;0
x-mozilla-html: FALSE
version:        2.1
end:            vcard


--------------1BD8989A0AA5ADDEC50D057E--

= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.