Alpha vs Vax Date "Rounding" problem

[Guy Werry]

Regarding the problem quoted below, consider using Qtp to create the
subfile.  Quiz has a nasty habit of making numeric items float in subfiles
despite what the original definition is.  Qtp keeps the data type intact,
by-passing the issue of precision loss/problems with float data.

Guy Werry
Senior Systems Analyst
Hudson Bay Mining & Smelting

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]
<mailto:[mailto:c.harkes@phycomp-components.com]> 
Sent:	Thursday, January 17, 2002 10:19 AM
To:	powerh-l@lists.swau.edu <mailto: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 !!!!