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.