"Re: Powerhouse Portable Subfile problem on Alpha using date 2002/01/17"

Johan Koelewijn j.koelewijn@thegreenery.com
Thu, 17 Jan 2002 16:34:37 +0100


Hi,

When I do this, I get : *W* ** Data conversion errors: 1
When I define d_date as : define d_date date = 20020117 it works correct.

On alpha openvms 7.3 , ph 7.10g1

Johan Koelewijn
Greenery International
> 
> 
> 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.
>