Sysdate problem in Quiz

[Hamilton, Allison]

FYI From one of our developers "We reworked the MPE/iX specific SYSDATE
logic between versions 819C4 and 819C5 so that we no longer use the HP C
library routines that introduced this problem.  Users no longer need to set
the TZ variable in order to have PowerHouse report the correct date."

-----Original Message-----
From: Brown, Doug [mailto:DBrown@alliedcarpets.com]
Sent: Tuesday, October 03, 2000 4:11 AM
To: 'Powerh-l@sphere.swau.edu'
Subject: Re: Sysdate problem in Quiz


Hi List

We had the same problem with the date in Quiz a few weeks back.  One of my
colleagues contacted COGNOS in Bracknell, UK and they gave us the following
info:

For Info -  In case  you have any overnight jobs that use SYSDATE

SYSDATE now returns the correct date between midnight and 05:00 am

Previously it returned the previous days date.

Explanation

To overcome an HP millennium bug Cognos had to read the date directly from
the Hardware clock rather than via intrinsic's. This clock runs on New York
time.
This bug only affects SYSDATE ; SYSTIME has always been ok.
The fix was to add a line in the SETPOWERHOUSE UDC to set the TZ ( Time
Zone) systems variable.
Somebody may need to remember this for the next PowerHouse upgrade.


Regards
Douglas Brown

         work: +44 (0)1689 89-5105
       mobile: +44 (0)7710 71-6147
fax/voicemail: +44 (0)870 168-3769
     web-mail: Mailto:dgb@fsmail.net


= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
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
This list is closed, thus to post to the list, you must be a subscriber.