<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns="http://www.w3.org/TR/REC-html40" xmlns:v =
"urn:schemas-microsoft-com:vml" xmlns:o =
"urn:schemas-microsoft-com:office:office" xmlns:w =
"urn:schemas-microsoft-com:office:word" xmlns:st1 =
"urn:schemas-microsoft-com:office:smarttags"><HEAD>
<META content="text/html; charset=us-ascii" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.6001.19046"><!--[if !mso]>
<STYLE>v\:* {
BEHAVIOR: url(#default#VML)
}
o\:* {
BEHAVIOR: url(#default#VML)
}
w\:* {
BEHAVIOR: url(#default#VML)
}
.shape {
BEHAVIOR: url(#default#VML)
}
</STYLE>
<![endif]--><o:SmartTagType name="place"
namespaceuri="urn:schemas-microsoft-com:office:smarttags"></o:SmartTagType><o:SmartTagType
name="City"
namespaceuri="urn:schemas-microsoft-com:office:smarttags"></o:SmartTagType><!--[if !mso]>
<STYLE>st1\:* {
BEHAVIOR: url(#default#ieooui)
}
</STYLE>
<![endif]-->
<STYLE>@font-face {
font-family: Tahoma;
}
@font-face {
font-family: Californian FB;
}
@page Section1 {size: 8.5in 11.0in; margin: 1.0in 1.25in 1.0in 1.25in; }
P.MsoNormal {
MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"; COLOR: black; FONT-SIZE: 12pt
}
LI.MsoNormal {
MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"; COLOR: black; FONT-SIZE: 12pt
}
DIV.MsoNormal {
MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"; COLOR: black; FONT-SIZE: 12pt
}
A:link {
COLOR: blue; TEXT-DECORATION: underline
}
SPAN.MsoHyperlink {
COLOR: blue; TEXT-DECORATION: underline
}
A:visited {
COLOR: blue; TEXT-DECORATION: underline
}
SPAN.MsoHyperlinkFollowed {
COLOR: blue; TEXT-DECORATION: underline
}
P {
FONT-FAMILY: "Times New Roman"; COLOR: black; MARGIN-LEFT: 0in; FONT-SIZE: 12pt; MARGIN-RIGHT: 0in; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto
}
PRE {
MARGIN: 0in 0in 0pt; FONT-FAMILY: "Courier New"; COLOR: black; FONT-SIZE: 10pt
}
SPAN.EmailStyle19 {
FONT-FAMILY: Arial; COLOR: navy; mso-style-type: personal-reply
}
DIV.Section1 {
page: Section1
}
</STYLE>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></HEAD>
<BODY lang=EN-US link=blue bgColor=white vLink=blue>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial>
<DIV dir=ltr align=left><SPAN class=579425712-01062011><FONT color=#0000ff
size=2 face=Arial>OK, well the problem is I made a mistake. I feel really
stupid having to admit it. If you look below in my define statements, my
last 2 are converting B-date and E-date and they should be converting full-b and
full-e. I discovered that when I was trying one of the suggested
solutions. </FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=579425712-01062011><FONT color=#0000ff
size=2 face=Arial>I was hoping to slink out of the room without having to admit
it. :( </FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=579425712-01062011></SPAN><SPAN
class=579425712-01062011><FONT color=#0000ff size=2 face=Arial>That wasn't the
only problem from the start. The dictionary had a stupid redefine that I
fixed. It might have worked at that point had I done the coding
right.</FONT></SPAN></DIV></FONT></DIV>
<DIV><FONT color=#0000ff size=2 face=Arial></FONT> </DIV><!-- Converted from text/rtf format -->
<P><SPAN lang=en-us><SPAN class=756403918-01062011><FONT
face="Californian FB">Thanks for the ideas and support!</FONT></SPAN></SPAN></P>
<P><SPAN lang=en-us><FONT face="Californian FB">Barb</FONT></SPAN> </P>
<DIV> </DIV><BR>
<DIV dir=ltr lang=en-us class=OutlookMessageHeader align=left>
<HR tabIndex=-1>
<FONT size=2 face=Tahoma><B>From:</B> Pickering, John (NORBORD)
[mailto:John.Pickering@norbord.com] <BR><B>Sent:</B> Tuesday, May 31, 2011 2:25
PM<BR><B>To:</B> Zanotelli, Barb<BR><B>Subject:</B> RE: Powerhouse dictionary
not matching Image<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV class=Section1>
<P class=MsoNormal><FONT color=navy size=2 face=Arial><SPAN
style="FONT-FAMILY: Arial; COLOR: navy; FONT-SIZE: 10pt">So please tell us how
you did that!!<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT color=navy size=2 face=Arial><SPAN
style="FONT-FAMILY: Arial; COLOR: navy; FONT-SIZE: 10pt"><o:p> </o:p></SPAN></FONT></P>
<DIV>
<DIV style="TEXT-ALIGN: center" class=MsoNormal align=center><FONT color=black
size=3 face="Times New Roman"><SPAN style="COLOR: windowtext; FONT-SIZE: 12pt">
<HR tabIndex=-1 align=center SIZE=2 width="100%">
</SPAN></FONT></DIV>
<P class=MsoNormal><B><FONT color=black size=2 face=Tahoma><SPAN
style="FONT-FAMILY: Tahoma; COLOR: windowtext; FONT-SIZE: 10pt; FONT-WEIGHT: bold">From:</SPAN></FONT></B><FONT
color=black size=2 face=Tahoma><SPAN
style="FONT-FAMILY: Tahoma; COLOR: windowtext; FONT-SIZE: 10pt">
powerh-l-bounces+john.pickering=norbord.com@lists.sowder.com
[mailto:powerh-l-bounces+john.pickering=norbord.com@lists.sowder.com] <B><SPAN
style="FONT-WEIGHT: bold">On Behalf Of </SPAN></B>Zanotelli, Barb<BR><B><SPAN
style="FONT-WEIGHT: bold">Sent:</SPAN></B> Tuesday, May 31, 2011 3:21
PM<BR><B><SPAN style="FONT-WEIGHT: bold">To:</SPAN></B>
o.kappert@qc.aibn.com<BR><B><SPAN style="FONT-WEIGHT: bold">Cc:</SPAN></B>
powerh-l@lists.sowder.com<BR><B><SPAN
style="FONT-WEIGHT: bold">Subject:</SPAN></B> RE: Powerhouse dictionary not
matching Image</SPAN></FONT><FONT color=black><SPAN
style="COLOR: windowtext"><o:p></o:p></SPAN></FONT></P></DIV>
<P class=MsoNormal><FONT color=black size=3 face="Times New Roman"><SPAN
style="FONT-SIZE: 12pt"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT color=blue size=2 face=Arial><SPAN
style="FONT-FAMILY: Arial; COLOR: blue; FONT-SIZE: 10pt">I got it to
work!!</SPAN></FONT><o:p></o:p></P>
<P class=MsoNormal><FONT color=black size=3 face="Times New Roman"><SPAN
style="FONT-SIZE: 12pt"> <o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT color=blue size=2 face=Arial><SPAN
style="FONT-FAMILY: Arial; COLOR: blue; FONT-SIZE: 10pt">thanks for all your
help!</SPAN></FONT><o:p></o:p></P>
<DIV>
<P class=MsoNormal><FONT color=black size=3 face="Times New Roman"><SPAN
style="FONT-SIZE: 12pt"> <o:p></o:p></SPAN></FONT></P></DIV>
<P><FONT color=black size=3 face="Californian FB"><SPAN
style="FONT-FAMILY: 'Californian FB'; FONT-SIZE: 12pt"><!-- Converted from text/rtf format -->Barb</SPAN></FONT>
<o:p></o:p></P>
<DIV>
<P class=MsoNormal><FONT color=black size=3 face="Times New Roman"><SPAN
style="FONT-SIZE: 12pt"> <o:p></o:p></SPAN></FONT></P></DIV>
<P class=MsoNormal><FONT color=black size=3 face="Times New Roman"><SPAN
style="FONT-SIZE: 12pt"><o:p> </o:p></SPAN></FONT></P>
<DIV style="TEXT-ALIGN: center" class=MsoNormal align=center><FONT color=black
size=3 face="Times New Roman"><SPAN style="FONT-SIZE: 12pt">
<HR tabIndex=-1 align=center SIZE=2 width="100%">
</SPAN></FONT></DIV>
<P style="MARGIN-BOTTOM: 12pt" class=MsoNormal><B><FONT color=black size=2
face=Tahoma><SPAN
style="FONT-FAMILY: Tahoma; FONT-SIZE: 10pt; FONT-WEIGHT: bold">From:</SPAN></FONT></B><FONT
size=2 face=Tahoma><SPAN style="FONT-FAMILY: Tahoma; FONT-SIZE: 10pt">
o.kappert@qc.aibn.com [mailto:o.kappert@qc.aibn.com] <BR><B><SPAN
style="FONT-WEIGHT: bold">Sent:</SPAN></B> Tuesday, May 31, 2011 10:19
AM<BR><B><SPAN style="FONT-WEIGHT: bold">Cc:</SPAN></B> Zanotelli, Barb;
powerh-l@lists.sowder.com<BR><B><SPAN
style="FONT-WEIGHT: bold">Subject:</SPAN></B> Re: Powerhouse dictionary not
matching Image</SPAN></FONT><o:p></o:p></P>
<P class=MsoNormal><FONT color=black size=3 face="Times New Roman"><SPAN
style="FONT-SIZE: 12pt">Query is rather smart / dumb depending on how you look
at it. The <BR><BR><o:p></o:p></SPAN></FONT></P><PRE><FONT color=black size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt">f SL-DATE-TIME=201104282400<o:p></o:p></SPAN></FONT></PRE><PRE><FONT color=black size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"><o:p> </o:p></SPAN></FONT></PRE><PRE><FONT color=black size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt">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.<o:p></o:p></SPAN></FONT></PRE><PRE><FONT color=black size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"><o:p> </o:p></SPAN></FONT></PRE><PRE><FONT color=black size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt">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.<o:p></o:p></SPAN></FONT></PRE><PRE><FONT color=black size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"><o:p> </o:p></SPAN></FONT></PRE><PRE><FONT color=black size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt">Olav.<o:p></o:p></SPAN></FONT></PRE>
<P class=MsoNormal><FONT color=black size=3 face="Times New Roman"><SPAN
style="FONT-SIZE: 12pt"><BR><st1:City w:st="on"><st1:place
w:st="on">Pickering</st1:place></st1:City>, John (NORBORD) wrote:
<o:p></o:p></SPAN></FONT></P><PRE wrap=""><FONT color=black size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt">I try never to use NUMERIC. Powerhouse will use floating point storage<o:p></o:p></SPAN></FONT></PRE><PRE><FONT color=black size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt">for this and there always seems to be some corner case where it won't<o:p></o:p></SPAN></FONT></PRE><PRE><FONT color=black size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt">work :( Try to use ZONED or INTEGER.<o:p></o:p></SPAN></FONT></PRE><PRE><FONT color=black size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"><o:p> </o:p></SPAN></FONT></PRE><PRE><FONT color=black size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt">How about if you try <o:p></o:p></SPAN></FONT></PRE><PRE><FONT color=black size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"> <o:p></o:p></SPAN></FONT></PRE>
<BLOCKQUOTE style="MARGIN-TOP: 5pt; MARGIN-BOTTOM: 5pt" type="cite"><PRE wrap=""><FONT color=black size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt">access ddcl01<o:p></o:p></SPAN></FONT></PRE><PRE><FONT color=black size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt">report sl-date-time pic "^^^^^^^^^^^^" signif 12<o:p></o:p></SPAN></FONT></PRE><PRE><FONT color=black size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt">go<o:p></o:p></SPAN></FONT></PRE><PRE><FONT color=black size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"> <o:p></o:p></SPAN></FONT></PRE></BLOCKQUOTE><PRE wrap=""><FONT color=black size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt">Just to see what is really in that field.<o:p></o:p></SPAN></FONT></PRE><PRE><FONT color=black size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"><o:p> </o:p></SPAN></FONT></PRE><PRE><FONT color=black size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt">-----Original Message-----<o:p></o:p></SPAN></FONT></PRE><PRE><FONT color=black size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt">From: <A href="mailto:powerh-l-bounces+john.pickering=norbord.com@lists.sowder.com">powerh-l-bounces+john.pickering=norbord.com@lists.sowder.com</A><o:p></o:p></SPAN></FONT></PRE><PRE><FONT color=black size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt">[<A href="mailto:powerh-l-bounces+john.pickering=norbord.com@lists.sowder.com">mailto:powerh-l-bounces+john.pickering=norbord.com@lists.sowder.com</A>] On<o:p></o:p></SPAN></FONT></PRE><PRE><FONT color=black size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt">Behalf Of Zanotelli, Barb<o:p></o:p></SPAN></FONT></PRE><PRE><FONT color=black size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt">Sent: Tuesday, May 31, 2011 10:39 AM<o:p></o:p></SPAN></FONT></PRE><PRE><FONT color=black size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt">To: Bob Deskin<o:p></o:p></SPAN></FONT></PRE><PRE><FONT color=black size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt">Cc: <A href="mailto:powerh-l-bounces+bob.deskin=ca.ibm.com@lists.sowder.com">powerh-l-bounces+bob.deskin=ca.ibm.com@lists.sowder.com</A>;<o:p></o:p></SPAN></FONT></PRE><PRE><FONT color=black size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"><A href="mailto:powerh-l@lists.sowder.com">powerh-l@lists.sowder.com</A><o:p></o:p></SPAN></FONT></PRE><PRE><FONT color=black size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt">Subject: RE: Powerhouse dictionary not matching Image<o:p></o:p></SPAN></FONT></PRE><PRE><FONT color=black size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"><o:p> </o:p></SPAN></FONT></PRE><PRE><FONT color=black size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt">I know there is data for 201104282400, I can see it in query.<o:p></o:p></SPAN></FONT></PRE><PRE><FONT color=black size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"> <o:p></o:p></SPAN></FONT></PRE>
<BLOCKQUOTE style="MARGIN-TOP: 5pt; MARGIN-BOTTOM: 5pt" type="cite"><PRE wrap=""><FONT color=black size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt">b=imcl01.rec<o:p></o:p></SPAN></FONT></PRE><PRE><FONT color=black size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt">s=ddcl01<o:p></o:p></SPAN></FONT></PRE><PRE><FONT color=black size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt">f SL-DATE-TIME=201104282400<o:p></o:p></SPAN></FONT></PRE><PRE><FONT color=black size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"> <o:p></o:p></SPAN></FONT></PRE></BLOCKQUOTE><PRE wrap=""><FONT color=black size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt">31 ENTRIES QUALIFIED<o:p></o:p></SPAN></FONT></PRE><PRE><FONT color=black size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"> <o:p></o:p></SPAN></FONT></PRE><PRE wrap=""><FONT color=black size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt">This is my selection:<o:p></o:p></SPAN></FONT></PRE><PRE><FONT color=black size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"> <o:p></o:p></SPAN></FONT></PRE><PRE><FONT color=black size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"> ACCESS DDCL01<o:p></o:p></SPAN></FONT></PRE><PRE><FONT color=black size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"> <o:p></o:p></SPAN></FONT></PRE><PRE><FONT color=black size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"> DEFINE B-DATE CHAR*8 = PARM PROMPT "ENTER BEGIN DATE (CCYYMMDD): "<o:p></o:p></SPAN></FONT></PRE><PRE><FONT color=black size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"> DEFINE E-DATE CHAR*8 = PARM PROMPT "ENTER END DATE (CCYYMMDD): "<o:p></o:p></SPAN></FONT></PRE><PRE><FONT color=black size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"> DEFINE FULL-B CHAR*12 = PACK(B-DATE + "2400")<o:p></o:p></SPAN></FONT></PRE><PRE><FONT color=black size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"> DEFINE FULL-E CHAR*12 = PACK(E-DATE + "2400")<o:p></o:p></SPAN></FONT></PRE><PRE><FONT color=black size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"> DEFINE INT-B NUM*12 = NCONVERT(B-DATE)<o:p></o:p></SPAN></FONT></PRE><PRE><FONT color=black size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"> DEFINE INT-E NUM*12 = NCONVERT(E-DATE)<o:p></o:p></SPAN></FONT></PRE><PRE><FONT color=black size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"> <o:p></o:p></SPAN></FONT></PRE><PRE><FONT color=black size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"> ;SELECT IF SL-DATE-TIME >= INT-B &<o:p></o:p></SPAN></FONT></PRE><PRE><FONT color=black size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"> ; AND SL-DATE-TIME <= INT-E &<o:p></o:p></SPAN></FONT></PRE><PRE><FONT color=black size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"> SELECT IF SL-DATE-TIME >= 201104282400000000 &<o:p></o:p></SPAN></FONT></PRE><PRE><FONT color=black size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"> AND SL-DATE-TIME <= 201104282400000000 &<o:p></o:p></SPAN></FONT></PRE><PRE><FONT color=black size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"> AND TRAN-FLAG <> "DL" AND TRAN-FLAG <> "CL"<o:p></o:p></SPAN></FONT></PRE><PRE><FONT color=black size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"><o:p> </o:p></SPAN></FONT></PRE><PRE><FONT color=black size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt">As you can see I started out prompting for the dates and adding the time<o:p></o:p></SPAN></FONT></PRE><PRE><FONT color=black size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt">at the end. When that didn't work I put in the actual date just to see<o:p></o:p></SPAN></FONT></PRE><PRE><FONT color=black size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt">what was and was not working.<o:p></o:p></SPAN></FONT></PRE><PRE><FONT color=black size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt">I tried add 0's at the end but that produced nothing also.<o:p></o:p></SPAN></FONT></PRE><PRE><FONT color=black size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"><o:p> </o:p></SPAN></FONT></PRE><PRE><FONT color=black size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt">It was also suggested to try the dateextract function but that was not<o:p></o:p></SPAN></FONT></PRE><PRE><FONT color=black size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt">successful either. <o:p></o:p></SPAN></FONT></PRE><PRE><FONT color=black size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"><o:p> </o:p></SPAN></FONT></PRE><PRE><FONT color=black size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt">thanks<o:p></o:p></SPAN></FONT></PRE><PRE><FONT color=black size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"><o:p> </o:p></SPAN></FONT></PRE><PRE><FONT color=black size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt">Barb<o:p></o:p></SPAN></FONT></PRE><PRE><FONT color=black size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"><o:p> </o:p></SPAN></FONT></PRE><PRE><FONT color=black size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt">-----Original Message-----<o:p></o:p></SPAN></FONT></PRE><PRE><FONT color=black size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt">From: Bob Deskin [<A href="mailto:Bob.Deskin@ca.ibm.com">mailto:Bob.Deskin@ca.ibm.com</A>] <o:p></o:p></SPAN></FONT></PRE><PRE><FONT color=black size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt">Sent: Friday, May 27, 2011 1:34 PM<o:p></o:p></SPAN></FONT></PRE><PRE><FONT color=black size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt">To: Zanotelli, Barb<o:p></o:p></SPAN></FONT></PRE><PRE><FONT color=black size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt">Cc: <A href="mailto:powerh-l@lists.sowder.com">powerh-l@lists.sowder.com</A>;<o:p></o:p></SPAN></FONT></PRE><PRE><FONT color=black size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"><A href="mailto:powerh-l-bounces+bob.deskin=ca.ibm.com@lists.sowder.com">powerh-l-bounces+bob.deskin=ca.ibm.com@lists.sowder.com</A><o:p></o:p></SPAN></FONT></PRE><PRE><FONT color=black size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt">Subject: Re: Powerhouse dictionary not matching Image<o:p></o:p></SPAN></FONT></PRE><PRE><FONT color=black size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"><o:p> </o:p></SPAN></FONT></PRE><PRE><FONT color=black size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"><o:p> </o:p></SPAN></FONT></PRE><PRE><FONT color=black size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt">I wonder if you could be running into floating point issues. PowerHouse<o:p></o:p></SPAN></FONT></PRE><PRE><FONT color=black size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt">does most expression processing using floating point. In the example you<o:p></o:p></SPAN></FONT></PRE><PRE><FONT color=black size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt">gave us, which specific value can you find? Are you using SELECT IF<o:p></o:p></SPAN></FONT></PRE><PRE><FONT color=black size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt">SL-DATE-TIME = <value>? And what values are available between the two<o:p></o:p></SPAN></FONT></PRE><PRE><FONT color=black size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt">values you have in your example.<o:p></o:p></SPAN></FONT></PRE><PRE><FONT color=black size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"><o:p> </o:p></SPAN></FONT></PRE><PRE><FONT color=black size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt">Bob<o:p></o:p></SPAN></FONT></PRE><PRE><FONT color=black size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"><o:p> </o:p></SPAN></FONT></PRE><PRE><FONT color=black size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"><o:p> </o:p></SPAN></FONT></PRE><PRE><FONT color=black size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"><o:p> </o:p></SPAN></FONT></PRE><PRE><FONT color=black size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt">From: "Zanotelli, Barb" <A href="mailto:BarbZ@millercompressing.com"><BarbZ@millercompressing.com></A><o:p></o:p></SPAN></FONT></PRE><PRE><FONT color=black size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt">To: <A href="mailto:powerh-l@lists.sowder.com"><powerh-l@lists.sowder.com></A><o:p></o:p></SPAN></FONT></PRE><PRE><FONT color=black size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt">Date: 2011-05-27 01:34 PM<o:p></o:p></SPAN></FONT></PRE><PRE><FONT color=black size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt">Subject: Powerhouse dictionary not matching Image<o:p></o:p></SPAN></FONT></PRE><PRE><FONT color=black size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt">Sent by: <A href="mailto:powerh-l-bounces+bob.deskin=ca.ibm.com@lists.sowder.com">powerh-l-bounces+bob.deskin=ca.ibm.com@lists.sowder.com</A><o:p></o:p></SPAN></FONT></PRE><PRE><FONT color=black size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"><o:p> </o:p></SPAN></FONT></PRE><PRE><FONT color=black size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"><o:p> </o:p></SPAN></FONT></PRE><PRE><FONT color=black size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"><o:p> </o:p></SPAN></FONT></PRE><PRE><FONT color=black size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt">Hello listers <o:p></o:p></SPAN></FONT></PRE><PRE><FONT color=black size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt">I have an image database that was defined in the Powerhouse dictionary<o:p></o:p></SPAN></FONT></PRE><PRE><FONT color=black size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt">way <o:p></o:p></SPAN></FONT></PRE><PRE><FONT color=black size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt">back when the dictionary was defined. I tried to do a Quiz select with <o:p></o:p></SPAN></FONT></PRE><PRE><FONT color=black size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt">the main search item but It would never get any results even though I <o:p></o:p></SPAN></FONT></PRE><PRE><FONT color=black size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt">could see what it should have found in Query. Obviously we have no <o:p></o:p></SPAN></FONT></PRE><PRE><FONT color=black size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt">Powerhouse programs accessing this database. I tried various ways of <o:p></o:p></SPAN></FONT></PRE><PRE><FONT color=black size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt">selecting and have narrowed it down to the fact that it will select a <o:p></o:p></SPAN></FONT></PRE><PRE><FONT color=black size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt">specific number (a date in this case) but will not when I do >= or <= as<o:p></o:p></SPAN></FONT></PRE><PRE><FONT color=black size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"><o:p> </o:p></SPAN></FONT></PRE><PRE><FONT color=black size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt">in "select if sl-date-time>= 201104282400 and sl-date-time<= <o:p></o:p></SPAN></FONT></PRE><PRE><FONT color=black size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt">201104302400". The dictionary element is defined as:<o:p></o:p></SPAN></FONT></PRE><PRE><FONT color=black size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"> Element SL-DATE-TIME & <o:p></o:p></SPAN></FONT></PRE><PRE><FONT color=black size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"> Numeric Size 012 & <o:p></o:p></SPAN></FONT></PRE><PRE><FONT color=black size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"> Leading Sign " " & <o:p></o:p></SPAN></FONT></PRE><PRE><FONT color=black size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"> Picture "^^^^^^^^^^^^" <o:p></o:p></SPAN></FONT></PRE><PRE><FONT color=black size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt">And the in the dataset it is defined as: <o:p></o:p></SPAN></FONT></PRE><PRE><FONT color=black size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"> Item SL-DATE-TIME Datatype Integer Signed Size 8 <o:p></o:p></SPAN></FONT></PRE><PRE><FONT color=black size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt">Image refers to it as an I4. Powerhouse version is 8.19.c2. <o:p></o:p></SPAN></FONT></PRE><PRE><FONT color=black size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt">Any ideas will be greatly appreciated! <o:p></o:p></SPAN></FONT></PRE><PRE><FONT color=black size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"><o:p> </o:p></SPAN></FONT></PRE><PRE><FONT color=black size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt">Barb -- <o:p></o:p></SPAN></FONT></PRE><PRE><FONT color=black size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt">= = = = = = = = = = = = = = = = = = = = = = = = = = = =<o:p></o:p></SPAN></FONT></PRE><PRE><FONT color=black size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"><o:p> </o:p></SPAN></FONT></PRE><PRE><FONT color=black size=2 face="Courier New"><SPAN style="FONT-SIZE: 10pt"> <o:p></o:p></SPAN></FONT></PRE></DIV></BODY></HTML>