<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
Barb:<br>
<br>
As the saying goes, "There are never stupid questions, only stupid
answers".<br>
<br>
Olav.<br>
<br>
Zanotelli, Barb wrote:
<blockquote
cite="mid51969F273346FD4CA3AFA5032D9A439505F40969@MCCO-EXCHANGE.mcco.int"
type="cite">
<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]-->
<div align="left" dir="ltr"><font color="#0000ff" face="Arial"
size="2">
<div align="left" dir="ltr"><span class="579425712-01062011"><font
color="#0000ff" face="Arial" size="2">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 align="left" dir="ltr"><span class="579425712-01062011"><font
color="#0000ff" face="Arial" size="2">I was hoping to slink out of the
room without having to admit it. :( </font></span></div>
<div align="left" dir="ltr"><span class="579425712-01062011"></span><span
class="579425712-01062011"><font color="#0000ff" face="Arial" size="2">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> </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 class="OutlookMessageHeader" align="left" dir="ltr" lang="en-us">
<hr tabindex="-1"><font face="Tahoma" size="2"><b>From:</b>
Pickering, John (NORBORD) [<a class="moz-txt-link-freetext" href="mailto:John.Pickering@norbord.com">mailto:John.Pickering@norbord.com</a>] <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 class="Section1">
<p class="MsoNormal"><font color="navy" face="Arial" size="2"><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" face="Arial" size="2"><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" face="Times New Roman" size="3"><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" face="Tahoma" size="2"><span
style="font-family: Tahoma; color: windowtext; font-size: 10pt; font-weight: bold;">From:</span></font></b><font
color="black" face="Tahoma" size="2"><span
style="font-family: Tahoma; color: windowtext; font-size: 10pt;">
<a class="moz-txt-link-abbreviated" href="mailto:powerh-l-bounces+john.pickering=norbord.com@lists.sowder.com">powerh-l-bounces+john.pickering=norbord.com@lists.sowder.com</a>
[<a class="moz-txt-link-freetext" href="mailto:powerh-l-bounces+john.pickering=norbord.com@lists.sowder.com">mailto:powerh-l-bounces+john.pickering=norbord.com@lists.sowder.com</a>] <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>
<a class="moz-txt-link-abbreviated" href="mailto:o.kappert@qc.aibn.com">o.kappert@qc.aibn.com</a><br>
<b><span style="font-weight: bold;">Cc:</span></b>
<a class="moz-txt-link-abbreviated" href="mailto:powerh-l@lists.sowder.com">powerh-l@lists.sowder.com</a><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" face="Times New Roman"
size="3"><span style="font-size: 12pt;"><o:p> </o:p></span></font></p>
<p class="MsoNormal"><font color="blue" face="Arial" size="2"><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" face="Times New Roman"
size="3"><span style="font-size: 12pt;"> <o:p></o:p></span></font></p>
<p class="MsoNormal"><font color="blue" face="Arial" size="2"><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" face="Times New Roman"
size="3"><span style="font-size: 12pt;"> <o:p></o:p></span></font></p>
</div>
<p><font color="black" face="Californian FB" size="3"><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" face="Times New Roman"
size="3"><span style="font-size: 12pt;"> <o:p></o:p></span></font></p>
</div>
<p class="MsoNormal"><font color="black" face="Times New Roman"
size="3"><span style="font-size: 12pt;"><o:p> </o:p></span></font></p>
<div style="text-align: center;" class="MsoNormal" align="center"><font
color="black" face="Times New Roman" size="3"><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" face="Tahoma" size="2"><span
style="font-family: Tahoma; font-size: 10pt; font-weight: bold;">From:</span></font></b><font
face="Tahoma" size="2"><span
style="font-family: Tahoma; font-size: 10pt;"> <a class="moz-txt-link-abbreviated" href="mailto:o.kappert@qc.aibn.com">o.kappert@qc.aibn.com</a>
[<a class="moz-txt-link-freetext" href="mailto:o.kappert@qc.aibn.com">mailto:o.kappert@qc.aibn.com</a>] <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;
<a class="moz-txt-link-abbreviated" href="mailto:powerh-l@lists.sowder.com">powerh-l@lists.sowder.com</a><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" face="Times New Roman"
size="3"><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" face="Courier New" size="2"><span
style="font-size: 10pt;">f SL-DATE-TIME=201104282400<o:p></o:p></span></font></pre>
<pre><font color="black" face="Courier New" size="2"><span
style="font-size: 10pt;"><o:p> </o:p></span></font></pre>
<pre><font color="black" face="Courier New" size="2"><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" face="Courier New" size="2"><span
style="font-size: 10pt;"><o:p> </o:p></span></font></pre>
<pre><font color="black" face="Courier New" size="2"><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" face="Courier New" size="2"><span
style="font-size: 10pt;"><o:p> </o:p></span></font></pre>
<pre><font color="black" face="Courier New" size="2"><span
style="font-size: 10pt;">Olav.<o:p></o:p></span></font></pre>
<p class="MsoNormal"><font color="black" face="Times New Roman"
size="3"><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" face="Courier New" size="2"><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" face="Courier New" size="2"><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" face="Courier New" size="2"><span
style="font-size: 10pt;">work :( Try to use ZONED or INTEGER.<o:p></o:p></span></font></pre>
<pre><font color="black" face="Courier New" size="2"><span
style="font-size: 10pt;"><o:p> </o:p></span></font></pre>
<pre><font color="black" face="Courier New" size="2"><span
style="font-size: 10pt;">How about if you try <o:p></o:p></span></font></pre>
<pre><font color="black" face="Courier New" size="2"><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" face="Courier New" size="2"><span
style="font-size: 10pt;">access ddcl01<o:p></o:p></span></font></pre>
<pre><font color="black" face="Courier New" size="2"><span
style="font-size: 10pt;">report sl-date-time pic "^^^^^^^^^^^^" signif 12<o:p></o:p></span></font></pre>
<pre><font color="black" face="Courier New" size="2"><span
style="font-size: 10pt;">go<o:p></o:p></span></font></pre>
<pre><font color="black" face="Courier New" size="2"><span
style="font-size: 10pt;"> <o:p></o:p></span></font></pre>
</blockquote>
<pre wrap=""><font color="black" face="Courier New" size="2"><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" face="Courier New" size="2"><span
style="font-size: 10pt;"><o:p> </o:p></span></font></pre>
<pre><font color="black" face="Courier New" size="2"><span
style="font-size: 10pt;">-----Original Message-----<o:p></o:p></span></font></pre>
<pre><font color="black" face="Courier New" size="2"><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" face="Courier New" size="2"><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" face="Courier New" size="2"><span
style="font-size: 10pt;">Behalf Of Zanotelli, Barb<o:p></o:p></span></font></pre>
<pre><font color="black" face="Courier New" size="2"><span
style="font-size: 10pt;">Sent: Tuesday, May 31, 2011 10:39 AM<o:p></o:p></span></font></pre>
<pre><font color="black" face="Courier New" size="2"><span
style="font-size: 10pt;">To: Bob Deskin<o:p></o:p></span></font></pre>
<pre><font color="black" face="Courier New" size="2"><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" face="Courier New" size="2"><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" face="Courier New" size="2"><span
style="font-size: 10pt;">Subject: RE: Powerhouse dictionary not matching Image<o:p></o:p></span></font></pre>
<pre><font color="black" face="Courier New" size="2"><span
style="font-size: 10pt;"><o:p> </o:p></span></font></pre>
<pre><font color="black" face="Courier New" size="2"><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" face="Courier New" size="2"><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" face="Courier New" size="2"><span
style="font-size: 10pt;">b=imcl01.rec<o:p></o:p></span></font></pre>
<pre><font color="black" face="Courier New" size="2"><span
style="font-size: 10pt;">s=ddcl01<o:p></o:p></span></font></pre>
<pre><font color="black" face="Courier New" size="2"><span
style="font-size: 10pt;">f SL-DATE-TIME=201104282400<o:p></o:p></span></font></pre>
<pre><font color="black" face="Courier New" size="2"><span
style="font-size: 10pt;"> <o:p></o:p></span></font></pre>
</blockquote>
<pre wrap=""><font color="black" face="Courier New" size="2"><span
style="font-size: 10pt;">31 ENTRIES QUALIFIED<o:p></o:p></span></font></pre>
<pre><font color="black" face="Courier New" size="2"><span
style="font-size: 10pt;"> <o:p></o:p></span></font></pre>
<pre wrap=""><font color="black" face="Courier New" size="2"><span
style="font-size: 10pt;">This is my selection:<o:p></o:p></span></font></pre>
<pre><font color="black" face="Courier New" size="2"><span
style="font-size: 10pt;"> <o:p></o:p></span></font></pre>
<pre><font color="black" face="Courier New" size="2"><span
style="font-size: 10pt;"> ACCESS DDCL01<o:p></o:p></span></font></pre>
<pre><font color="black" face="Courier New" size="2"><span
style="font-size: 10pt;"> <o:p></o:p></span></font></pre>
<pre><font color="black" face="Courier New" size="2"><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" face="Courier New" size="2"><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" face="Courier New" size="2"><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" face="Courier New" size="2"><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" face="Courier New" size="2"><span
style="font-size: 10pt;"> DEFINE INT-B NUM*12 = NCONVERT(B-DATE)<o:p></o:p></span></font></pre>
<pre><font color="black" face="Courier New" size="2"><span
style="font-size: 10pt;"> DEFINE INT-E NUM*12 = NCONVERT(E-DATE)<o:p></o:p></span></font></pre>
<pre><font color="black" face="Courier New" size="2"><span
style="font-size: 10pt;"> <o:p></o:p></span></font></pre>
<pre><font color="black" face="Courier New" size="2"><span
style="font-size: 10pt;"> ;SELECT IF SL-DATE-TIME >= INT-B &<o:p></o:p></span></font></pre>
<pre><font color="black" face="Courier New" size="2"><span
style="font-size: 10pt;"> ; AND SL-DATE-TIME <= INT-E &<o:p></o:p></span></font></pre>
<pre><font color="black" face="Courier New" size="2"><span
style="font-size: 10pt;"> SELECT IF SL-DATE-TIME >= 201104282400000000 &<o:p></o:p></span></font></pre>
<pre><font color="black" face="Courier New" size="2"><span
style="font-size: 10pt;"> AND SL-DATE-TIME <= 201104282400000000 &<o:p></o:p></span></font></pre>
<pre><font color="black" face="Courier New" size="2"><span
style="font-size: 10pt;"> AND TRAN-FLAG <> "DL" AND TRAN-FLAG <> "CL"<o:p></o:p></span></font></pre>
<pre><font color="black" face="Courier New" size="2"><span
style="font-size: 10pt;"><o:p> </o:p></span></font></pre>
<pre><font color="black" face="Courier New" size="2"><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" face="Courier New" size="2"><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" face="Courier New" size="2"><span
style="font-size: 10pt;">what was and was not working.<o:p></o:p></span></font></pre>
<pre><font color="black" face="Courier New" size="2"><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" face="Courier New" size="2"><span
style="font-size: 10pt;"><o:p> </o:p></span></font></pre>
<pre><font color="black" face="Courier New" size="2"><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" face="Courier New" size="2"><span
style="font-size: 10pt;">successful either. <o:p></o:p></span></font></pre>
<pre><font color="black" face="Courier New" size="2"><span
style="font-size: 10pt;"><o:p> </o:p></span></font></pre>
<pre><font color="black" face="Courier New" size="2"><span
style="font-size: 10pt;">thanks<o:p></o:p></span></font></pre>
<pre><font color="black" face="Courier New" size="2"><span
style="font-size: 10pt;"><o:p> </o:p></span></font></pre>
<pre><font color="black" face="Courier New" size="2"><span
style="font-size: 10pt;">Barb<o:p></o:p></span></font></pre>
<pre><font color="black" face="Courier New" size="2"><span
style="font-size: 10pt;"><o:p> </o:p></span></font></pre>
<pre><font color="black" face="Courier New" size="2"><span
style="font-size: 10pt;">-----Original Message-----<o:p></o:p></span></font></pre>
<pre><font color="black" face="Courier New" size="2"><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" face="Courier New" size="2"><span
style="font-size: 10pt;">Sent: Friday, May 27, 2011 1:34 PM<o:p></o:p></span></font></pre>
<pre><font color="black" face="Courier New" size="2"><span
style="font-size: 10pt;">To: Zanotelli, Barb<o:p></o:p></span></font></pre>
<pre><font color="black" face="Courier New" size="2"><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" face="Courier New" size="2"><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" face="Courier New" size="2"><span
style="font-size: 10pt;">Subject: Re: Powerhouse dictionary not matching Image<o:p></o:p></span></font></pre>
<pre><font color="black" face="Courier New" size="2"><span
style="font-size: 10pt;"><o:p> </o:p></span></font></pre>
<pre><font color="black" face="Courier New" size="2"><span
style="font-size: 10pt;"><o:p> </o:p></span></font></pre>
<pre><font color="black" face="Courier New" size="2"><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" face="Courier New" size="2"><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" face="Courier New" size="2"><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" face="Courier New" size="2"><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" face="Courier New" size="2"><span
style="font-size: 10pt;">values you have in your example.<o:p></o:p></span></font></pre>
<pre><font color="black" face="Courier New" size="2"><span
style="font-size: 10pt;"><o:p> </o:p></span></font></pre>
<pre><font color="black" face="Courier New" size="2"><span
style="font-size: 10pt;">Bob<o:p></o:p></span></font></pre>
<pre><font color="black" face="Courier New" size="2"><span
style="font-size: 10pt;"><o:p> </o:p></span></font></pre>
<pre><font color="black" face="Courier New" size="2"><span
style="font-size: 10pt;"><o:p> </o:p></span></font></pre>
<pre><font color="black" face="Courier New" size="2"><span
style="font-size: 10pt;"><o:p> </o:p></span></font></pre>
<pre><font color="black" face="Courier New" size="2"><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" face="Courier New" size="2"><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" face="Courier New" size="2"><span
style="font-size: 10pt;">Date: 2011-05-27 01:34 PM<o:p></o:p></span></font></pre>
<pre><font color="black" face="Courier New" size="2"><span
style="font-size: 10pt;">Subject: Powerhouse dictionary not matching Image<o:p></o:p></span></font></pre>
<pre><font color="black" face="Courier New" size="2"><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" face="Courier New" size="2"><span
style="font-size: 10pt;"><o:p> </o:p></span></font></pre>
<pre><font color="black" face="Courier New" size="2"><span
style="font-size: 10pt;"><o:p> </o:p></span></font></pre>
<pre><font color="black" face="Courier New" size="2"><span
style="font-size: 10pt;"><o:p> </o:p></span></font></pre>
<pre><font color="black" face="Courier New" size="2"><span
style="font-size: 10pt;">Hello listers <o:p></o:p></span></font></pre>
<pre><font color="black" face="Courier New" size="2"><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" face="Courier New" size="2"><span
style="font-size: 10pt;">way <o:p></o:p></span></font></pre>
<pre><font color="black" face="Courier New" size="2"><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" face="Courier New" size="2"><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" face="Courier New" size="2"><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" face="Courier New" size="2"><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" face="Courier New" size="2"><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" face="Courier New" size="2"><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" face="Courier New" size="2"><span
style="font-size: 10pt;"><o:p> </o:p></span></font></pre>
<pre><font color="black" face="Courier New" size="2"><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" face="Courier New" size="2"><span
style="font-size: 10pt;">201104302400". The dictionary element is defined as:<o:p></o:p></span></font></pre>
<pre><font color="black" face="Courier New" size="2"><span
style="font-size: 10pt;"> Element SL-DATE-TIME & <o:p></o:p></span></font></pre>
<pre><font color="black" face="Courier New" size="2"><span
style="font-size: 10pt;"> Numeric Size 012 & <o:p></o:p></span></font></pre>
<pre><font color="black" face="Courier New" size="2"><span
style="font-size: 10pt;"> Leading Sign " " & <o:p></o:p></span></font></pre>
<pre><font color="black" face="Courier New" size="2"><span
style="font-size: 10pt;"> Picture "^^^^^^^^^^^^" <o:p></o:p></span></font></pre>
<pre><font color="black" face="Courier New" size="2"><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" face="Courier New" size="2"><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" face="Courier New" size="2"><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" face="Courier New" size="2"><span
style="font-size: 10pt;">Any ideas will be greatly appreciated! <o:p></o:p></span></font></pre>
<pre><font color="black" face="Courier New" size="2"><span
style="font-size: 10pt;"><o:p> </o:p></span></font></pre>
<pre><font color="black" face="Courier New" size="2"><span
style="font-size: 10pt;">Barb -- <o:p></o:p></span></font></pre>
<pre><font color="black" face="Courier New" size="2"><span
style="font-size: 10pt;">= = = = = = = = = = = = = = = = = = = = = = = = = = = =<o:p></o:p></span></font></pre>
<pre><font color="black" face="Courier New" size="2"><span
style="font-size: 10pt;"><o:p> </o:p></span></font></pre>
<pre><font color="black" face="Courier New" size="2"><span
style="font-size: 10pt;"> <o:p></o:p></span></font></pre>
</div>
</blockquote>
</body>
</html>