Powerhouse dictionary not matching Image

[Pickering, John (NORBORD)]

I try never to use NUMERIC. Powerhouse will use floating point storage
for this and there always seems to be some corner case where it won't
work :( Try to use ZONED or INTEGER.

How about if you try 
>access ddcl01
>report sl-date-time pic "^^^^^^^^^^^^" signif 12
>go
Just to see what is really in that field.

-----Original Message-----
From: powerh-l-bounces+john.pickering=norbord.com at lists.sowder.com
[mailto:powerh-l-bounces+john.pickering=norbord.com at lists.sowder.com] On
Behalf Of Zanotelli, Barb
Sent: Tuesday, May 31, 2011 10:39 AM
To: Bob Deskin
Cc: powerh-l-bounces+bob.deskin=ca.ibm.com at lists.sowder.com;
powerh-l at lists.sowder.com
Subject: RE: Powerhouse dictionary not matching Image

I know there is data for 201104282400, I can see it in query.
>b=imcl01.rec
>s=ddcl01
>f SL-DATE-TIME=201104282400
31  ENTRIES QUALIFIED
>
This is my selection:
 
    ACCESS DDCL01
         
    DEFINE B-DATE CHAR*8 = PARM PROMPT "ENTER BEGIN DATE (CCYYMMDD): "
    DEFINE E-DATE CHAR*8 = PARM PROMPT "ENTER END DATE (CCYYMMDD): "
    DEFINE FULL-B CHAR*12 = PACK(B-DATE + "2400")
    DEFINE FULL-E CHAR*12 = PACK(E-DATE + "2400")
    DEFINE INT-B NUM*12 = NCONVERT(B-DATE)
    DEFINE INT-E NUM*12 = NCONVERT(E-DATE)
      
    ;SELECT IF SL-DATE-TIME >= INT-B &
    ;     AND SL-DATE-TIME <= INT-E &
    SELECT IF SL-DATE-TIME >= 201104282400000000 &
          AND SL-DATE-TIME <= 201104282400000000 &
          AND TRAN-FLAG <> "DL" AND TRAN-FLAG <> "CL"

As you can see I started out prompting for the dates and adding the time
at the end.  When that didn't work I put in the actual date just to see
what was and was not working.
I tried add 0's at the end but that produced nothing also.

It was also suggested to try the dateextract function but that was not
successful either.  

thanks

Barb

-----Original Message-----
From: Bob Deskin [mailto:Bob.Deskin at ca.ibm.com] 
Sent: Friday, May 27, 2011 1:34 PM
To: Zanotelli, Barb
Cc: powerh-l at lists.sowder.com;
powerh-l-bounces+bob.deskin=ca.ibm.com at lists.sowder.com
Subject: Re: Powerhouse dictionary not matching Image


I wonder if you could be running into floating point issues. PowerHouse
does most expression processing using floating point. In the example you
gave us, which specific value can you find? Are you using SELECT IF
SL-DATE-TIME = <value>? And what values are available between the two
values you have in your example.

Bob



From:   "Zanotelli, Barb" <BarbZ at millercompressing.com>
To:     <powerh-l at lists.sowder.com>
Date:   2011-05-27 01:34 PM
Subject:        Powerhouse dictionary not matching Image
Sent by:        powerh-l-bounces+bob.deskin=ca.ibm.com at lists.sowder.com



Hello listers 
I have an image database that was defined in the Powerhouse dictionary
way 
back when the dictionary was defined.  I tried to do a Quiz select with 
the main search item but It would never get any results even though I 
could see what it should have found in Query. Obviously we have no 
Powerhouse programs accessing this database.   I tried various ways of 
selecting and have narrowed it down to the fact that it will select a 
specific number (a date in this case) but will not when I do >= or <= as

in "select if sl-date-time>= 201104282400 and sl-date-time<= 
201104302400". The dictionary element is defined as:
  Element SL-DATE-TIME & 
    Numeric Size 012 & 
    Leading Sign " " & 
    Picture "^^^^^^^^^^^^" 
And the in the dataset it is defined as: 
    Item SL-DATE-TIME     Datatype Integer Signed   Size 8 
Image refers to it as an I4. Powerhouse version is 8.19.c2. 
Any ideas will be greatly appreciated! 

Barb -- 
= = = = = = = = = = = = = = = = = = = = = = = = = = = =