Powerhouse dictionary not matching Image

[Michael Cousins]

I have two guesses.

Therefore the selection value has to be restated as :

  select if sl-date-time>= 2011042824000000 and sl-date-time<=
2011043024000000

I would experiment with the number of zeroes required.


If that doesn't work try the dateextract function.


 select if 20110429 <= dateextract(sl-date-time,date) and 20110430 <=
dateextract(sl-date-time,date)





                                                                                                                     
  From:       "Zanotelli, Barb" <BarbZ at millercompressing.com>                                                        
                                                                                                                     
  To:         <powerh-l at lists.sowder.com>                                                                            
                                                                                                                     
  Date:       05/27/2011 01:36 PM                                                                                    
                                                                                                                     
  Subject:    Powerhouse dictionary not matching Image                                                               
                                                                                                                     
  Sent by:    powerh-l-bounces+michael.cousins=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.




-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20110527/3a21920b/attachment.htm 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: graycol.gif
Type: image/gif
Size: 105 bytes
Desc: not available
Url : http://lists.sowder.com/pipermail/powerh-l/attachments/20110527/3a21920b/attachment.gif 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: ecblank.gif
Type: image/gif
Size: 45 bytes
Desc: not available
Url : http://lists.sowder.com/pipermail/powerh-l/attachments/20110527/3a21920b/attachment-0001.gif