Powerhouse dictionary not matching Image

[Matt Ohmes]

Hi Barb,
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.
Something like:
    SELECT IF SL-DATE-TIME >= 201104282400000000 &
         ; AND SL-DATE-TIME <= 201104282400000000 &
          AND TRAN-FLAG <> "DL" AND TRAN-FLAG <> "CL"

Once you find something that pulls back values, then switch it around and 
look for the upper range.
Hope that helps,
Matt



From:   "Zanotelli, Barb" <BarbZ at millercompressing.com>
To:     "Bob Deskin" <Bob.Deskin at ca.ibm.com>
Cc:     powerh-l-bounces+bob.deskin=ca.ibm.com at lists.sowder.com, 
powerh-l at lists.sowder.com
Date:   05/31/2011 09:41 AM
Subject:        RE: Powerhouse dictionary not matching Image
Sent by:        powerh-l-bounces+mohmes=us.ibm.com at lists.sowder.com



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 -- 
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l at lists.sowder.com
Subscribe: 'subscribe' in message body to 
powerh-l-request at lists.sowder.com
Unsubscribe: 'unsubscribe &lt;password&gt;' in message body to 
powerh-l-request at lists.sowder.com
http://lists.sowder.com/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.
Add 'site:lists.sowder.com powerh-l' to your search terms to search the 
list archive at Google.


-- 
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l at lists.sowder.com
Subscribe: 'subscribe' in message body to 
powerh-l-request at lists.sowder.com
Unsubscribe: 'unsubscribe &lt;password&gt;' in message body to 
powerh-l-request at lists.sowder.com
http://lists.sowder.com/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.
Add 'site:lists.sowder.com powerh-l' to your search terms to search the 
list archive at Google.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20110531/4a5b7876/attachment.htm