Sysdate problem in Quiz

[Brown, Doug]

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.