Powerhouse Portable Subfile problem on Alpha using date 2002/
01/17
Hamilton, Allison
Allison.Hamilton@Cognos.COM
Thu, 17 Jan 2002 10:32:59 -0500
If you define it as
define d_date date = 20020117
it will work correctly.
There is possibly a rounding error or truncating problem in the portable
float code that is causing the problem that you are showing. It is stored
in the file as +.200201169999999968E+008 on ALPHA and on VAX it is stored in
the .ps file as +.200201170000000000E+008. (They do have quite different
float capabilities, VAX and ALPHA.)
-----Original Message-----
From: C. Harkes [mailto:c.harkes@phycomp-components.com]
Sent: Thursday, January 17, 2002 10:19 AM
To: powerh-l@lists.swau.edu
Subject: Powerhouse Portable Subfile problem on Alpha using date
2002/01/17
Our System : OPENVMS on ALPHA
The following problem looks like a powerhouse alpha bug , on VAX the bug
doesn't appear ! It only happens with portable subfiles.
2002/01/17 DATE IS WRITTEN WRONG TO PORTABLE SUBFILE !!! WHEN YOU CHECK IT
2002-01-16 WILL APPEAR !
Q U I Z (7.10.G1)
Copyright 1998 COGNOS INC. (ALPHA)
Licensed PH-AXP-RUNTIME-WITH-REPORTING for customer: 8036050001 PHILIPS
COMPONENTS BV AXP
> can cle
> define d_date = 20020117
> set subfile name sf_dateproblem keep portable
> rep summ d_date
> go
*W* The permanent subfile SF_DATEPROBLEM will be cleared.
Records selected: 0
Records written: 1
> access *sf_dateproblem
> rep d_date format YYYYMMDD
> go
2002/01/17 Phycomp Manufacturing and Quality System PAGE
1
D_DATE
2002/01/16
==================================== NON PORTABLE IS GOOD !!!!
=====================================
MAQS> quiz auto=dateproblem.qzs
Q U I Z (7.10.G1)
Copyright 1998 COGNOS INC. (ALPHA)
Licensed PH-AXP-RUNTIME-WITH-REPORTING for customer: 8036050001 PHILIPS
COMPONENTS BV AXP
> can cle
> define d_date = 20020117
> set subfile name sf_dateproblem keep
> rep summ d_date
> go
Records selected: 0
Records written: 1
> access *sf_dateproblem
> rep d_date format YYYYMMDD
> go
2002/01/17 Phycomp Manufacturing and Quality System PAGE
1
D_DATE
2002/01/17
Records selected: 1
Lines printed: 3
Pages printed: 1
>
With kind regards,
Cees Harkes / Software Engineer ( ISA)
Email : c.harkes@phycomp-components.com
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.swau.edu
Subscribe: "subscribe" in message body to powerh-l-request@lists.swau.edu
Unsubscribe: "unsubscribe" in message body to
powerh-l-request@lists.swau.edu
http://lists.swau.edu/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.
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.