<font size=2 face="sans-serif">Hi Barb,</font>
<br><font size=2 face="sans-serif">Try just using part of the range to
see what it will find. Comment out part of the range select and see if
you find anything.</font>
<br><font size=2 face="sans-serif">Something like:</font>
<br><tt><font size=2> SELECT IF SL-DATE-TIME >= 201104282400000000
&<br>
; AND SL-DATE-TIME <= 201104282400000000
&<br>
AND TRAN-FLAG <> "DL"
AND TRAN-FLAG <> "CL"</font></tt>
<br>
<br><tt><font size=2>Once you find something that pulls back values, then
switch it around and look for the upper range.</font></tt>
<br><tt><font size=2>Hope that helps,</font></tt>
<br><tt><font size=2>Matt</font></tt>
<br>
<br>
<br>
<br><font size=1 color=#5f5f5f face="sans-serif">From:
</font><font size=1 face="sans-serif">"Zanotelli, Barb"
<BarbZ@millercompressing.com></font>
<br><font size=1 color=#5f5f5f face="sans-serif">To:
</font><font size=1 face="sans-serif">"Bob Deskin"
<Bob.Deskin@ca.ibm.com></font>
<br><font size=1 color=#5f5f5f face="sans-serif">Cc:
</font><font size=1 face="sans-serif">powerh-l-bounces+bob.deskin=ca.ibm.com@lists.sowder.com,
powerh-l@lists.sowder.com</font>
<br><font size=1 color=#5f5f5f face="sans-serif">Date:
</font><font size=1 face="sans-serif">05/31/2011 09:41 AM</font>
<br><font size=1 color=#5f5f5f face="sans-serif">Subject:
</font><font size=1 face="sans-serif">RE: Powerhouse
dictionary not matching Image</font>
<br><font size=1 color=#5f5f5f face="sans-serif">Sent by:
</font><font size=1 face="sans-serif">powerh-l-bounces+mohmes=us.ibm.com@lists.sowder.com</font>
<br>
<hr noshade>
<br>
<br>
<br><tt><font size=2>I know there is data for 201104282400, I can see it
in query.<br>
>b=imcl01.rec<br>
>s=ddcl01<br>
>f SL-DATE-TIME=201104282400<br>
31 ENTRIES QUALIFIED<br>
><br>
This is my selection:<br>
<br>
ACCESS DDCL01<br>
<br>
DEFINE B-DATE CHAR*8 = PARM PROMPT "ENTER BEGIN DATE
(CCYYMMDD): "<br>
DEFINE E-DATE CHAR*8 = PARM PROMPT "ENTER END DATE (CCYYMMDD):
"<br>
DEFINE FULL-B CHAR*12 = PACK(B-DATE + "2400")<br>
DEFINE FULL-E CHAR*12 = PACK(E-DATE + "2400")<br>
DEFINE INT-B NUM*12 = NCONVERT(B-DATE)<br>
DEFINE INT-E NUM*12 = NCONVERT(E-DATE)<br>
<br>
;SELECT IF SL-DATE-TIME >= INT-B &<br>
; AND SL-DATE-TIME <= INT-E &<br>
SELECT IF SL-DATE-TIME >= 201104282400000000 &<br>
AND SL-DATE-TIME <= 201104282400000000
&<br>
AND TRAN-FLAG <> "DL"
AND TRAN-FLAG <> "CL"<br>
<br>
As you can see I started out prompting for the dates and adding the time<br>
at the end. When that didn't work I put in the actual date just to
see<br>
what was and was not working.<br>
I tried add 0's at the end but that produced nothing also.<br>
<br>
It was also suggested to try the dateextract function but that was not<br>
successful either. <br>
<br>
thanks<br>
<br>
Barb<br>
<br>
-----Original Message-----<br>
From: Bob Deskin [</font></tt><a href=mailto:Bob.Deskin@ca.ibm.com><tt><font size=2>mailto:Bob.Deskin@ca.ibm.com</font></tt></a><tt><font size=2>]
<br>
Sent: Friday, May 27, 2011 1:34 PM<br>
To: Zanotelli, Barb<br>
Cc: powerh-l@lists.sowder.com;<br>
powerh-l-bounces+bob.deskin=ca.ibm.com@lists.sowder.com<br>
Subject: Re: Powerhouse dictionary not matching Image<br>
<br>
<br>
I wonder if you could be running into floating point issues. PowerHouse<br>
does most expression processing using floating point. In the example you<br>
gave us, which specific value can you find? Are you using SELECT IF<br>
SL-DATE-TIME = <value>? And what values are available between the
two<br>
values you have in your example.<br>
<br>
Bob<br>
<br>
<br>
<br>
From: "Zanotelli, Barb" <BarbZ@millercompressing.com><br>
To: <powerh-l@lists.sowder.com><br>
Date: 2011-05-27 01:34 PM<br>
Subject: Powerhouse dictionary not matching
Image<br>
Sent by: powerh-l-bounces+bob.deskin=ca.ibm.com@lists.sowder.com<br>
<br>
<br>
<br>
Hello listers <br>
I have an image database that was defined in the Powerhouse dictionary<br>
way <br>
back when the dictionary was defined. I tried to do a Quiz select
with <br>
the main search item but It would never get any results even though I <br>
could see what it should have found in Query. Obviously we have no <br>
Powerhouse programs accessing this database. I tried various ways
of <br>
selecting and have narrowed it down to the fact that it will select a <br>
specific number (a date in this case) but will not when I do >= or <=
as<br>
<br>
in "select if sl-date-time>= 201104282400 and sl-date-time<=
<br>
201104302400". The dictionary element is defined as:<br>
Element SL-DATE-TIME & <br>
Numeric Size 012 & <br>
Leading Sign " " & <br>
Picture "^^^^^^^^^^^^" <br>
And the in the dataset it is defined as: <br>
Item SL-DATE-TIME Datatype Integer Signed
Size 8 <br>
Image refers to it as an I4. Powerhouse version is 8.19.c2. <br>
Any ideas will be greatly appreciated! <br>
<br>
Barb -- <br>
= = = = = = = = = = = = = = = = = = = = = = = = = = = =<br>
Mailing list: powerh-l@lists.sowder.com<br>
Subscribe: 'subscribe' in message body to <br>
powerh-l-request@lists.sowder.com<br>
Unsubscribe: 'unsubscribe &lt;password&gt;' in message body to
<br>
powerh-l-request@lists.sowder.com<br>
</font></tt><a href="http://lists.sowder.com/mailman/listinfo/powerh-l"><tt><font size=2>http://lists.sowder.com/mailman/listinfo/powerh-l</font></tt></a><tt><font size=2><br>
This list is closed, thus to post to the list you must be a subscriber.<br>
Add 'site:lists.sowder.com powerh-l' to your search terms to search the
<br>
list archive at Google.<br>
<br>
<br>
-- <br>
= = = = = = = = = = = = = = = = = = = = = = = = = = = =<br>
Mailing list: powerh-l@lists.sowder.com<br>
Subscribe: 'subscribe' in message body to powerh-l-request@lists.sowder.com<br>
Unsubscribe: 'unsubscribe &lt;password&gt;' in message body to
powerh-l-request@lists.sowder.com<br>
</font></tt><a href="http://lists.sowder.com/mailman/listinfo/powerh-l"><tt><font size=2>http://lists.sowder.com/mailman/listinfo/powerh-l</font></tt></a><tt><font size=2><br>
This list is closed, thus to post to the list you must be a subscriber.<br>
Add 'site:lists.sowder.com powerh-l' to your search terms to search the
list archive at Google.<br>
</font></tt>
<br>