Powerhouse dictionary not matching Image

Wed Jun 1 15:53:58 CDT 2011

Barb:

As the saying goes, "There are never stupid questions, only stupid answers".

Olav.

Zanotelli, Barb wrote:

> 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>
>
>[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 <mailto:powerh-l-bounces+bob.deskin=ca.ibm.com at lists.sowder.com>;
>
>powerh-l at lists.sowder.com <mailto: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 <mailto:powerh-l at lists.sowder.com>;
>
>powerh-l-bounces+bob.deskin=ca.ibm.com at lists.sowder.com <mailto: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 <mailto: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/86eac449/attachment-0001.htm 