y2k revisited?

Thu, 26 Feb 2004 15:45:38 -0500

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

------_=_NextPart_001_01C3FCA8.A9A640FA
Content-Type: text/plain

The INPUT CENTURY option and the DEFAULT CENTURY options are two separate
options. the DEFAULT CENTURY is what is used when processing and formatting.
The INPUT CENTURY is used when prompting the user in QUICK. We did not do a
windowing century for existing data for obvious reasons.

Is the dictionary you're using the same one as in 8.19? The default for
DEFAULT CENTURY is still 19, so if you created a test dictionary from
scratch and did not say DEFAULT CENTURY 20, you'll get this error. What was
the DEFAULT CENTURY in the dictionary in 8.19?

I'm trying to get all the information. It is possible that something was
changed between 8.19 and 8.49.
Bob Deskin              
Senior Product Manager, Application Development Tools, Cognos Inc. 
bob.deskin@cognos.com (613) 738-1338 ext 7268 FAX: (613) 727-1178 
3755 Riverside Drive P.O. Box 9707 Stn. T, Ottawa ON K1G 4K9 CANADA 

-----Original Message-----
From: Pickering, John (NORBORD) [mailto:PICKERIJ@norbord.com] 
Sent: February 26, 2004 3:38 PM
To: 'Deskin, Bob'; Powerhouse List (E-mail)
Subject: RE: y2k revisited?

Bob

Take a look at the pdl option statement parameter in my original message. I
understood this to mean that 19 is the default century for dates where yy is
>= 50. Not correct?

Please note that 8.19 works fine and 8.49 fails -- so what's changed between
these versions?

Regards,
JWP

-----Original Message-----
From: Deskin, Bob [mailto:Bob.Deskin@Cognos.COM]
Sent: Thursday, February 26, 2004 3:25 PM
To: 'Pickering, John (NORBORD)'; Powerhouse List (E-mail)
Cc: Deskin, Bob
Subject: RE: y2k revisited?

The issue here is that the date is declared as CENTURY EXCLUDED. Any century
excluded date is assumed to be in the default century. The option is named
"INPUT CENTRUY" and applies to input only. It does not apply to existing
data not does it apply to century excluded dates. It was designed so that
pre-existing (pre-Y2K) screens did not have to be modified where they
allowed a year entry without the century into a century included date.
Century excluded dates still had to be converted.

So the defined item gives you 19000229 which is an invalid date because
there was no Feb 29, 1900 based on the rule of 400.

Bob Deskin              
Senior Product Manager, Application Development Tools, Cognos Inc. 
bob.deskin@cognos.com (613) 738-1338 ext 7268 FAX: (613) 727-1178 
3755 Riverside Drive, Ottawa ON K1G 4K9 CANADA 

-----Original Message----- 
From: Pickering, John (NORBORD) [mailto:PICKERIJ@norbord.com
<mailto:PICKERIJ@norbord.com> ] 
Sent: February 26, 2004 3:19 PM 
To: Powerhouse List (E-mail) 
Cc: Deskin Bob (E-mail) 
Subject: y2k revisited? 

Anybody got any ideas about this one? 

I've logged a "case" with Cognos but I thought somebody out there might have
found and fixed this one already. We're moving to a new machine and a new
version of MPE and are taking the opportunity to upgrade PowerHouse versions
at the same time. So what's with the error below in 8.49.C?

The dictionary options include: 

  Century INCLUDED & 
  Input Century 19 From Year 50 & 

Any help appreciated. 

Regards, 
JWP 

Q U I Z   (PowerHouse  8.19.C4) 
Copyright 1999 COGNOS INCORPORATED 
Norbord Industries Inc. 

> def d-date-ce date century excluded = 000229 
> rep all 
> go 

04/02/26                    Norbord Industries Inc.                    PAGE 
1 

  D-DATE-CE 

  00/02/29 

> def d-date-ce date century excluded = 000229 
> rep all 
> go 

04/02/26                    Norbord Industries Inc.                    PAGE 
1 

  D-DATE-CE 

  ######## 

? 

Records selected:  0 
Lines printed:     3 
Pages printed:     1 

** Data conversion errors: 1 

> 

This message may contain privileged and/or confidential information.  If you
have received this e-mail in error or are not the intended recipient, you
may not use, copy, disseminate or distribute it; do not open any
attachments, delete it immediately from your system and notify the sender
promptly by e-mail that you have done so.  Thank you.

------_=_NextPart_001_01C3FCA8.A9A640FA
Content-Type: text/html

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=US-ASCII">
<TITLE>Message</TITLE>

<META content="MSHTML 6.00.2800.1400" name=GENERATOR></HEAD>
<BODY>
<DIV>The 
INPUT CENTURY option and the DEFAULT CENTURY options are two separate options. 
the DEFAULT CENTURY is what is used when processing and formatting. The INPUT 
CENTURY is used when prompting the user in QUICK. We did not do a windowing 
century for existing data for obvious reasons.</DIV>
<DIV>&nbsp;</DIV>
<DIV>Is the 
dictionary you're using the same one as in 8.19? The default for DEFAULT CENTURY 
is still 19, so if you created a test dictionary from scratch and did not say 
DEFAULT CENTURY 20, you'll get this error. What was the DEFAULT CENTURY in the 
dictionary in 8.19?</DIV>
<DIV>&nbsp;</DIV>
<DIV>I'm 
trying to get all the information. It is possible that something was changed 
between 8.19 and 8.49.</DIV>
<DIV>
Bob 
Deskin&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
 Senior Product 
Manager, Application Development Tools, Cognos Inc. bob.deskin@cognos.com (613) 738-1338 ext 7268 
FAX: (613) 727-1178 3755 Riverside Drive P.O. Box 9707 Stn. T, Ottawa ON K1G 4K9 
CANADA </DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
 <DIV></DIV>
 <DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>-----Original Message----- From: Pickering, John 
 (NORBORD) [mailto:PICKERIJ@norbord.com] Sent: February 26, 2004 
 3:38 PM To: 'Deskin, Bob'; Powerhouse List 
 (E-mail) Subject: RE: y2k revisited? </DIV>
 <DIV>Bob</DIV>
 <DIV>&nbsp;</DIV>
 <DIV>Take 
 a look at the pdl option statement parameter in my original message. I 
 understood this to mean that 19 is the default century for dates where yy is 
 &gt;= 50. Not correct?</DIV>
 <DIV>&nbsp;</DIV>
 <DIV>Please note that 8.19 works fine and 8.49 fails -- so what's changed 
 between these versions?</DIV>
 <DIV>&nbsp;</DIV>
 <DIV>Regards,</DIV>
 <DIV>JWP</DIV>
 <DIV>&nbsp;</DIV>
 <DIV class=OutlookMessageHeader dir=ltr align=left>-----Original Message----- From: Deskin, Bob 
 [mailto:Bob.Deskin@Cognos.COM] Sent: Thursday, February 26, 2004 
 3:25 PM To: 'Pickering, John (NORBORD)'; Powerhouse List 
 (E-mail) Cc: Deskin, Bob Subject: RE: y2k 
 revisited? </DIV>
 The issue here is that the date is declared as CENTURY 
 EXCLUDED. Any century excluded date is assumed to be in the default century. 
 The option is named "INPUT CENTRUY" and applies to input only. It does not 
 apply to existing data not does it apply to century excluded dates. It was 
 designed so that pre-existing (pre-Y2K) screens did not have to be modified 
 where they allowed a year entry without the century into a century included 
 date. Century excluded dates still had to be converted.
 So the defined item gives you 19000229 which is an invalid 
 date because there was no Feb 29, 1900 based on the rule of 400.
 Bob 
 Deskin&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
 Senior Product Manager, Application Development Tools, 
 Cognos Inc. bob.deskin@cognos.com (613) 738-1338 ext 
 7268 FAX: (613) 727-1178 3755 Riverside Drive, Ottawa 
 ON K1G 4K9 CANADA 
 -----Original Message----- From: 
 Pickering, John (NORBORD) [<A 
 href="mailto:PICKERIJ@norbord.com">mailto:PICKERIJ@norbord.com</A>] 
 Sent: February 26, 2004 3:19 PM To: Powerhouse List (E-mail) Cc: Deskin Bob 
 (E-mail) Subject: y2k revisited? 
 Anybody got any ideas about this one? 
 I've logged a "case" with Cognos but I thought somebody out 
 there might have found and fixed this one already. We're moving to a new 
 machine and a new version of MPE and are taking the opportunity to upgrade 
 PowerHouse versions at the same time. So what's with the error below in 
 8.49.C?
 The dictionary options include: 
 &nbsp; Century INCLUDED &amp; &nbsp; 
 Input Century 19 From Year 50 &amp; 
 Any help appreciated. 
 Regards, JWP 
 Q U I Z&nbsp;&nbsp; (PowerHouse&nbsp; 8.19.C4) 
 Copyright 1999 COGNOS INCORPORATED Norbord Industries Inc. 
 &gt; def d-date-ce date century excluded = 000229 
 &gt; rep all &gt; go 
 04/02/26&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
 Norbord Industries 
 Inc.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
 PAGE 1 
 &nbsp; D-DATE-CE 
 &nbsp; 00/02/29 
 Q U I Z&nbsp;&nbsp; (PowerHouse&nbsp; 8.49.C) Copyright 2003 COGNOS INCORPORATED Norbord 
 Ind. 
 &gt; def d-date-ce date century excluded = 000229 
 &gt; rep all &gt; go 
 04/02/26&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
 Norbord Industries 
 Inc.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
 PAGE 1 
 &nbsp; D-DATE-CE 
 &nbsp; ######## 
 ? 
 Records selected:&nbsp; 0 Lines 
 printed:&nbsp;&nbsp;&nbsp;&nbsp; 3 Pages 
 printed:&nbsp;&nbsp;&nbsp;&nbsp; 1 
 ** Data conversion errors: 1 
 &gt; 
 This message may contain privileged and/or confidential 
 information.&nbsp; If you have received this e-mail in error or are not the 
 intended recipient, you may not use, copy, disseminate or distribute it; do 
 not open any attachments, delete it immediately from your system and notify 
 the sender promptly by e-mail that you have done so.&nbsp; Thank 
 you.</BLOCKQUOTE></BODY></HTML>

This message may contain privileged and/or confidential information. If you have received this e-mail in error or are not the intended recipient, you may not use, copy, disseminate or distribute it; do not open any attachments, delete it immediately from your system and notify the sender promptly by e-mail that you have done so. Thank you.

------_=_NextPart_001_01C3FCA8.A9A640FA--