Powerhouse reporting incorrect date

Maloney, Charlie Charlie.Maloney@Cognos.com
Fri, 9 Jul 1999 16:52:45 -0400


Check the list for a message with:
 
  subject="RE: Y2K test fails" 
  sent="May 12, 1999" 
  from="bert.dn@arma.nl"

In the message bert explains the differences btw the hardware clock and the
software clock.
Sounds like you're in that 'timezone' situation.
In case you've deleted it, here's the text of that message:

<snip>

Have a look at document 73072 in the Cognos Supported Area or just look 
down here.
Description:

PowerHouse returns wrong date for SYSDATE


Solution:

There's a document available as part number 20625 and should be ordered 
when requesting PH729C8 or higher. As these questions are specific to 
MPE/iX operating systems, please be sure to check HP's web page at: 
http://jazz.external.hp.com/year2000/index.html

The PowerHouse 729C8 (and up) century 2000 data conversion features were 
achieved by reading the hardware clock instead of using the MPE/iX 
intrinsic CALENDAR. Clients using this feature must ensure that the 
hardware clock is set correctly. The underlying SYSDATE software is 
sensitive to the value in the environment variable, TZ, which refers to 
time zone. EST5EDT is the default. On the other hand, SYSTIME is based on 
the software clock which is not sensitive to the value in the environment 
variable, TZ. Therefore, it is imperative that the software clock and the 
hardware clock be synchronized to the second and if you are not in the 
Eastern Time Zone that the right TZ variable be used.

The TZ strings can used by the time and date library functions for 
adjustment to specific time zones. Refer to the description of the ctime 
function in chapter 3 of HP/XL C Library Reference Manual for details. The 
first line of each entry contains the time zone name followed by the 
Daylight Savings Time zone name, if appropriate. The next few lines contain 
the geographic locations associated with this time zone. The last line 
contains the TZ environment variable string that corresponds to this time 
zone. These can also be found in the file
TZTAB.LIB.SYS.


-----Oorspronkelijk bericht-----
Van:	Noack, Andreas M. [SMTP:Andreas.Noack@BetzDearborn.com]
Verzonden:	woensdag 12 mei 1999 9:43
Aan:	'POWERH-L@lists.swau.edu'
Onderwerp:	Y2K test fails

Hi all,

though we just opened a call with Cognos maybe the list can help, as it is
very urgent.

We set our test system (HP3000-Allbase-PH819) to the 31st of Dec 1999 today
to perform testing. Now obviously the function sydate returns still
12/05/1999. Anybody an idea where this is set?

Thank you very much in advance for help.

Kind regards
Andreas Noack
Hercules BetzDearborn
Development Group Europe
<snip>

Charlie Maloney
Technical Account Manager
Charlie.Maloney@cognos.com
PH:  781 313 2305
FX:  781 229 6426


-----Original Message-----
From: Joseph Northrop [mailto:jay_northrop@yahoo.com]
Sent: Friday, July 09, 1999 3:20 PM
To: powerh-l@lists.swau.edu
Subject: Powerhouse reporting incorrect date


We are running Powerhouse V8.19C2 on an HP3000 Mpe/IX
OS 5.5 Patch 6.  Today we found that Powerhouse
(QUIZ, QUICK, etc) is reporting a day ahead of
the actual system date.  We used the following
code:

DEFINE dt NUM*8 = SYSDATE

If the system date is 19990709, it reports 19990710.
We're not sure what is going on.  Can anyone help?

Thanks,
J. Northrop
Ajilon Programmer/Analyst
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

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