y2k revisited?
Pickering, John (NORBORD)
PICKERIJ@norbord.com
Fri, 27 Feb 2004 13:53:23 -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_01C3FD62.F97E4450
Content-Type: text/plain;
charset="iso-8859-1"
OK. I agree that 8.19 has a bug.
Further experimenting, this time with Quick, points out what is probably the
bug in version 8.19. I'm using a basic "screen, file, generate, go" screen
to test some phdate fields. In 8.19, with default century 19 and input
century 19 from 50, the date 00/02/29 is accepted; in 8.49 it is not.
Changing the default century to 20 makes no difference to 8.19 but allows
entry of this date in 8.49. I think 8.49 is behaving correctly according to
the docs.
So I'll go with your suggestion to change the default century to 20. The
data items that are still of type phdate are all in financial data and
interest in data from 2000 or earlier has pretty much expired.
Thanks for your interest and help.
Regards,
JWP
-----Original Message-----
From: Deskin, Bob [mailto:Bob.Deskin@Cognos.COM]
Sent: Thursday, February 26, 2004 4:26 PM
To: 'Pickering, John (NORBORD)'; Powerhouse List (E-mail)
Subject: RE: y2k revisited?
There was a change. Bug # 267500. And the problem was that the input century
was being applied to century excluded dates. The PDL manual specifically
says that the option applies to century included dates.
As I mentioned, this was done because we could not risk affecting existing
century excluded data on file.
If your defines and other century excluded data is all in the 21st century,
adding DEFAULT CENTURY 20 to the dictionary should solve the problem.
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
<mailto:PICKERIJ@norbord.com> ]
Sent: February 26, 2004 3:58 PM
To: 'Deskin, Bob'; Powerhouse List (E-mail)
Subject: RE: y2k revisited?
Bob
The dictionary is exactly the same, except recompiled with the new PH
version.
Looks like something has changed bewteen 8.19 and 8.49.
Here's the entire pdl options statement. Since there's no default century I
guess the default century is 19.
System Options &
Ascii7 &
Century INCLUDED &
Input Century 19 From Year 50 &
Character Set English &
Generic Retrieval Character "@" &
Date Format YYMMDD &
Date Separator "/" &
Decimal "." &
Message Substitution Character "^" &
Multiline Heading Character "^" &
Picture Substitution Character "^" &
Special Name Character "-/'" &
Sysmonths "JanFebMarAprMayJunJulAugSepOctNovDec" &
Title "Norbord Industries Inc." &
ASC ID Method Logonid
Regards,
JWP
-----Original Message-----
From: Deskin, Bob [ mailto:Bob.Deskin@Cognos.COM
<mailto:Bob.Deskin@Cognos.COM> ]
Sent: Thursday, February 26, 2004 3:46 PM
To: 'Pickering, John (NORBORD)'; Powerhouse List (E-mail)
Subject: RE: y2k revisited?
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
<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
<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
Q U I Z (PowerHouse 8.49.C)
Copyright 2003 COGNOS INCORPORATED
Norbord Ind.
> 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
>
------_=_NextPart_001_01C3FD62.F97E4450
Content-Type: text/html;
charset="iso-8859-1"
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<TITLE>RE: y2k revisited?</TITLE>
<META content="MSHTML 5.50.4522.1800" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=343015018-27022004>OK. I
agree that 8.19 has a bug.</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=343015018-27022004></SPAN></FONT> </DIV>
<DIV><SPAN class=343015018-27022004>
<DIV><SPAN class=750525615-27022004><FONT face=Arial><FONT color=#0000ff><FONT
size=2>Further experimenting, this time with Quick, points out what is
probably the bug in version 8.19. I'm using a basic "screen, file,
generate, go" screen to test some phdate fields. In 8.19, with default century
19 and input century 19 from 50, the date 00/02/29 is accepted; in 8.49 it
is not. Changing the default century to 20 makes no difference to 8.19 but
allows entry of this date in 8.49.<SPAN class=343015018-27022004> I think 8.49
is behaving correctly according to the
docs.</SPAN></FONT></FONT></FONT></SPAN></DIV>
<DIV><SPAN class=750525615-27022004><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=750525615-27022004><SPAN class=343015018-27022004><FONT
face=Arial color=#0000ff size=2>So I'll go with your suggestion to change the
default century to 20. The data items that are still of type phdate are all in
financial data and interest in data from 2000 or earlier has pretty much
expired.</FONT></SPAN></SPAN></DIV>
<DIV><SPAN class=750525615-27022004><SPAN class=343015018-27022004><FONT
face=Arial color=#0000ff size=2></FONT></SPAN></SPAN> </DIV>
<DIV><SPAN class=750525615-27022004><SPAN class=343015018-27022004><FONT
face=Arial color=#0000ff size=2>Thanks for your interest and
help.</FONT></SPAN></SPAN></DIV>
<DIV><SPAN class=750525615-27022004><SPAN class=343015018-27022004><FONT
face=Arial color=#0000ff size=2></FONT></SPAN></SPAN> </DIV>
<DIV><SPAN class=750525615-27022004><SPAN class=343015018-27022004><FONT
face=Arial color=#0000ff size=2>Regards,</FONT></SPAN></SPAN></DIV>
<DIV><SPAN class=750525615-27022004><SPAN class=343015018-27022004><FONT
face=Arial color=#0000ff size=2>JWP</FONT></SPAN></SPAN></DIV>
<DIV><SPAN class=750525615-27022004><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV></SPAN></DIV>
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Deskin, Bob
[mailto:Bob.Deskin@Cognos.COM]<BR><B>Sent:</B> Thursday, February 26, 2004 4:26
PM<BR><B>To:</B> 'Pickering, John (NORBORD)'; Powerhouse List
(E-mail)<BR><B>Subject:</B> RE: y2k revisited?<BR><BR></FONT></DIV>
<P><FONT size=2>There was a change. Bug # 267500. And the problem was that the
input century was being applied to century excluded dates. The PDL manual
specifically says that the option applies to century included dates.</FONT></P>
<P><FONT size=2>As I mentioned, this was done because we could not risk
affecting existing century excluded data on file.</FONT> </P>
<P><FONT size=2>If your defines and other century excluded data is all in the
21st century, adding DEFAULT CENTURY 20 to the dictionary should solve the
problem.</FONT></P>
<P><FONT size=2>Bob
Deskin
</FONT><BR><FONT size=2>Senior Product Manager, Application Development Tools,
Cognos Inc.</FONT> <BR><FONT size=2>bob.deskin@cognos.com (613) 738-1338 ext
7268 FAX: (613) 727-1178</FONT> <BR><FONT size=2>3755 Riverside Drive P.O. Box
9707 Stn. T, Ottawa ON K1G 4K9 CANADA</FONT> </P>
<P><FONT size=2>-----Original Message-----</FONT> <BR><FONT size=2>From:
Pickering, John (NORBORD) [<A
href="mailto:PICKERIJ@norbord.com">mailto:PICKERIJ@norbord.com</A>]
</FONT><BR><FONT size=2>Sent: February 26, 2004 3:58 PM</FONT> <BR><FONT
size=2>To: 'Deskin, Bob'; Powerhouse List (E-mail)</FONT> <BR><FONT
size=2>Subject: RE: y2k revisited?</FONT> </P><BR>
<P><FONT size=2>Bob</FONT> </P>
<P><FONT size=2>The dictionary is exactly the same, except recompiled with the
new PH version.</FONT> </P>
<P><FONT size=2>Looks like something has changed bewteen 8.19 and 8.49.</FONT>
</P>
<P><FONT size=2>Here's the entire pdl options statement. Since there's no
default century I guess the default century is 19.</FONT> </P>
<P><FONT size=2>System Options &</FONT> <BR><FONT size=2>Ascii7 &</FONT>
<BR><FONT size=2>Century INCLUDED &</FONT> <BR><FONT size=2>Input Century 19
>From Year 50 &</FONT> <BR><FONT size=2>Character Set English &</FONT>
<BR><FONT size=2>Generic Retrieval Character "@" &</FONT> <BR><FONT
size=2>Date Format YYMMDD &</FONT> <BR><FONT size=2>Date Separator "/"
&</FONT> <BR><FONT size=2>Decimal "." &</FONT> <BR><FONT size=2>Message
Substitution Character "^" &</FONT> <BR><FONT size=2>Multiline Heading
Character "^" &</FONT> <BR><FONT size=2>Picture Substitution Character "^"
&</FONT> <BR><FONT size=2>Special Name Character "-/'" &</FONT>
<BR><FONT size=2>Sysmonths "JanFebMarAprMayJunJulAugSepOctNovDec" &</FONT>
<BR><FONT size=2>Title "Norbord Industries Inc." &</FONT> <BR><FONT
size=2>ASC ID Method Logonid</FONT> </P>
<P><FONT size=2>Regards,</FONT> <BR><FONT size=2>JWP</FONT> </P><BR>
<P><FONT size=2>-----Original Message-----</FONT> <BR><FONT size=2>From: Deskin,
Bob [<A
href="mailto:Bob.Deskin@Cognos.COM">mailto:Bob.Deskin@Cognos.COM</A>]</FONT>
<BR><FONT size=2>Sent: Thursday, February 26, 2004 3:46 PM</FONT> <BR><FONT
size=2>To: 'Pickering, John (NORBORD)'; Powerhouse List (E-mail)</FONT>
<BR><FONT size=2>Subject: RE: y2k revisited?</FONT> </P><BR>
<P><FONT size=2>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.</FONT></P>
<P><FONT size=2>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?</FONT></P>
<P><FONT size=2>I'm trying to get all the information. It is possible that
something was changed between 8.19 and 8.49.</FONT> <BR><FONT size=2>Bob
Deskin
</FONT><BR><FONT size=2>Senior Product Manager, Application Development Tools,
Cognos Inc. </FONT><BR><FONT size=2>bob.deskin@cognos.com (613) 738-1338 ext
7268 FAX: (613) 727-1178 </FONT><BR><FONT size=2>3755 Riverside Drive P.O. Box
9707 Stn. T, Ottawa ON K1G 4K9 CANADA </FONT><BR><FONT size=2>-----Original
Message-----</FONT> <BR><FONT size=2>From: Pickering, John (NORBORD) [<A
href="mailto:PICKERIJ@norbord.com">mailto:PICKERIJ@norbord.com</A>]
</FONT><BR><FONT size=2>Sent: February 26, 2004 3:38 PM</FONT> <BR><FONT
size=2>To: 'Deskin, Bob'; Powerhouse List (E-mail)</FONT> <BR><FONT
size=2>Subject: RE: y2k revisited?</FONT> </P><BR>
<P><FONT size=2>Bob</FONT> </P>
<P><FONT size=2>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<SPAN class=343015018-27022004><FONT face=Arial color=#0000ff>
</FONT></SPAN></FONT><FONT size=2>>= 50. Not correct?</FONT> </P>
<P><FONT size=2>Please note that 8.19 works fine and 8.49 fails -- so what's
changed between these versions?</FONT> </P>
<P><FONT size=2>Regards,</FONT> <BR><FONT size=2>JWP</FONT> </P>
<P><FONT size=2>-----Original Message-----</FONT> <BR><FONT size=2>From: Deskin,
Bob [<A
href="mailto:Bob.Deskin@Cognos.COM">mailto:Bob.Deskin@Cognos.COM</A>]</FONT>
<BR><FONT size=2>Sent: Thursday, February 26, 2004 3:25 PM</FONT> <BR><FONT
size=2>To: 'Pickering, John (NORBORD)'; Powerhouse List (E-mail)</FONT>
<BR><FONT size=2>Cc: Deskin, Bob</FONT> <BR><FONT size=2>Subject: RE: y2k
revisited?</FONT> </P><BR>
<P><FONT size=2>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.</FONT></P>
<P><FONT size=2>Bob
Deskin
</FONT><BR><FONT size=2>Senior Product Manager, Application Development Tools,
Cognos Inc. </FONT><BR><FONT size=2>bob.deskin@cognos.com (613) 738-1338 ext
7268 FAX: (613) 727-1178 </FONT><BR><FONT size=2>3755 Riverside Drive, Ottawa ON
K1G 4K9 CANADA </FONT><BR><FONT size=2>-----Original Message-----
</FONT><BR><FONT size=2>From: Pickering, John (NORBORD) [<A
href="mailto:PICKERIJ@norbord.com">mailto:PICKERIJ@norbord.com</A>]
</FONT><BR><FONT size=2>Sent: February 26, 2004 3:19 PM </FONT><BR><FONT
size=2>To: Powerhouse List (E-mail) </FONT><BR><FONT size=2>Cc: Deskin Bob
(E-mail) </FONT><BR><FONT size=2>Subject: y2k revisited? </FONT></P><BR>
<P><FONT size=2>Anybody got any ideas about this one? </FONT><BR><FONT
size=2>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: </FONT></P>
<P><FONT size=2> Century INCLUDED & </FONT><BR><FONT size=2>
Input Century 19 From Year 50 & </FONT><BR><FONT size=2>Any help
appreciated. </FONT><BR><FONT size=2>Regards, </FONT><BR><FONT size=2>JWP
</FONT></P><BR>
<P><FONT size=2>Q U I Z (PowerHouse 8.19.C4) </FONT><BR><FONT
size=2>Copyright 1999 COGNOS INCORPORATED </FONT><BR><FONT size=2>Norbord
Industries Inc. </FONT><BR><FONT size=2>> def d-date-ce date century excluded
= 000229</FONT> <BR><FONT size=2>> rep all </FONT><BR><FONT size=2>> go
</FONT></P><BR>
<P><FONT
size=2>04/02/26
Norbord Industries
Inc.
PAGE </FONT><BR><FONT size=2>1 </FONT><BR><FONT size=2> D-DATE-CE
</FONT><BR><FONT size=2> 00/02/29 </FONT></P><BR><BR><BR>
<P><FONT size=2>Q U I Z (PowerHouse 8.49.C) </FONT><BR><FONT
size=2>Copyright 2003 COGNOS INCORPORATED </FONT><BR><FONT size=2>Norbord Ind.
</FONT><BR><FONT size=2>> def d-date-ce date century excluded = 000229
</FONT><BR><FONT size=2>> rep all </FONT><BR><FONT size=2>> go
</FONT></P><BR>
<P><FONT
size=2>04/02/26
Norbord Industries
Inc.
PAGE </FONT><BR><FONT size=2>1 </FONT><BR><FONT size=2> D-DATE-CE
</FONT><BR><FONT size=2> ######## </FONT></P><BR>
<P><FONT size=2>? </FONT><BR><FONT size=2>Records selected: 0
</FONT><BR><FONT size=2>Lines printed: 3
</FONT><BR><FONT size=2>Pages printed: 1
</FONT><BR><FONT size=2>** Data conversion errors: 1 </FONT><BR><FONT
size=2>> </FONT></P>
<P><FONT face=Arial color=#0000ff size=2></FONT> </P></BODY></HTML>
------_=_NextPart_001_01C3FD62.F97E4450--