Powerhouse dictionary not matching Image

[Zanotelli, Barb]

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/20110531/1eb9301c/attachment.htm