Powerhouse dictionary not matching Image

Wed Jun 1 13:40:44 CDT 2011

OK, well the problem is I made a mistake.  I feel really stupid having
to admit it.  If you look below in my define statements, my last 2 are
converting B-date and E-date and they should be converting full-b and
full-e.  I discovered that when I was trying one of the suggested
solutions.  
I was hoping to slink out of the room without having to admit it.  :( 
That wasn't the only problem from the start.  The dictionary had a
stupid redefine that I fixed.  It might have worked at that point had I
done the coding right.

Thanks for the ideas and support!

Barb 

________________________________

From: Pickering, John (NORBORD) [mailto:John.Pickering at norbord.com] 
Sent: Tuesday, May 31, 2011 2:25 PM
To: Zanotelli, Barb
Subject: RE: Powerhouse dictionary not matching Image

So please tell us how you did that!!

________________________________

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 3:21 PM
To: o.kappert at qc.aibn.com
Cc: powerh-l at lists.sowder.com
Subject: RE: Powerhouse dictionary not matching Image

I got it to work!!

thanks for all your help!

Barb 

________________________________

From: o.kappert at qc.aibn.com [mailto:o.kappert at qc.aibn.com] 
Sent: Tuesday, May 31, 2011 10:19 AM
Cc: Zanotelli, Barb; powerh-l at lists.sowder.com
Subject: Re: Powerhouse dictionary not matching Image

Query is rather smart / dumb depending on how you look at it.  The 

f SL-DATE-TIME=201104282400

statement uses the actual value as if it were character.  It then
converts the value into the same representation the item is.  This
usually results in the correct equate and therefore it found the record.

Now for Powerhouse,  the date-time numeric value might be converted to a
float value and then compared.  It is very unlikely that the float value
is the same as the item value and therefore the record will not be
found.  Define a string with the value and then convert it to the same
representation as the item value.

Olav.

Pickering, John (NORBORD) wrote: 

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>
<mailto:BarbZ at millercompressing.com> 
To:     <powerh-l at lists.sowder.com> <mailto: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 -- 
= = = = = = = = = = = = = = = = = = = = = = = = = = = =

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20110601/b3476cce/attachment-0001.htm 