powerh-l Digest, Vol 73, Issue 1

Wed Jun 1 12:02:23 CDT 2011

what was the answer to the problem?

----- Original Message ----
From: "powerh-l-request at lists.sowder.com" <powerh-l-request at lists.sowder.com>
To: powerh-l at lists.sowder.com
Sent: Wed, June 1, 2011 10:00:06 AM
Subject: powerh-l Digest, Vol 73, Issue 1

Send powerh-l mailing list submissions to
    powerh-l at lists.sowder.com

To subscribe or unsubscribe via the World Wide Web, visit
    http://lists.sowder.com/mailman/listinfo/powerh-l
or, via email, send a message with subject or body 'help' to
    powerh-l-request at lists.sowder.com

You can reach the person managing the list at
    powerh-l-owner at lists.sowder.com

When replying, please edit your Subject line so it is more specific
than "Re: Contents of powerh-l digest..."

Today's Topics:

  1. RE:Powerhouse dictionary not matching Image (Zanotelli, Barb)

----------------------------------------------------------------------

Message: 1
Date: Tue, 31 May 2011 14:21:23 -0500
From: "Zanotelli, Barb" <BarbZ at millercompressing.com>
Subject: RE: Powerhouse dictionary not matching Image
To: <o.kappert at qc.aibn.com>
Cc: powerh-l at lists.sowder.com
Message-ID:
    <51969F273346FD4CA3AFA5032D9A439505F4095C at MCCO-EXCHANGE.mcco.int>
Content-Type: text/plain; charset="us-ascii"

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.html

------------------------------

-- 
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l at lists.sowder.com
Subscribe: &quot;subscribe&quot; in message body to 
powerh-l-request at lists.sowder.com
Unsubscribe: &quot;unsubscribe &lt;password&gt;&quot; 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.

End of powerh-l Digest, Vol 73, Issue 1
***************************************