<HTML xmlns="http://www.w3.org/TR/REC-html40" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:v="urn:schemas-microsoft-com:vml" xmlns:w="urn:schemas-microsoft-com:office:word"><head><META content="text/html; charset=utf-8" http-equiv="Content-Type">
<meta content="text/html; charset=utf-8" http-equiv=Content-Type>
<meta content="Microsoft Word 12 (filtered medium)" name=Generator>
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
span.EmailStyle18
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:"Tahoma","sans-serif";
color:blue;
font-weight:normal;
font-style:normal;
text-decoration:none none;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page Section1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
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>
<DIV>
<div class=Section1>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif";
color:blue'>Dan,<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif";
color:blue'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif";
color:blue'>1 option, which you may consider a little outlandish, would be to not
create null values in the field in the first place. You can set an
initial value of space at the database level. You would of course loose the
ability to query on nulls using SQL, etc but it would resolve your sort issue.
Your decision as to whether the change is worth the effort!<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif";
color:blue'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif";
color:blue'>Regards,</span><span style='color:blue'><br>
</span><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif";
color:blue'>Gavin.</span><span style='color:blue'><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif";
color:blue'><o:p> </o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm'>
<p class=MsoNormal><b><span lang=EN-US style='font-size:10.0pt;font-family:
"Tahoma","sans-serif"'>From:</span></b><span lang=EN-US style='font-size:10.0pt;
font-family:"Tahoma","sans-serif"'> Ken Langendock
[mailto:ken.langendock@rogers.com] <br>
<b>Sent:</b> 24 February 2009 15:29<br>
<b>To:</b> 'Dan Lambshead'; powerh-l@lists.sowder.com<br>
<b>Subject:</b> RE: Sorting of null values in Powerhouse<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>I don’t think you have much choice.<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>You either use a DEFINE before the SORT, which doesn’t
impact performance very much.<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Or <o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>If you have a QTP extract, you could use an ITEM fieldname FINAL
“ “ if NULL EQ fieldname OF subfile<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Ken<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm'>
<p class=MsoNormal><b><span lang=EN-US style='font-size:10.0pt;font-family:
"Tahoma","sans-serif"'>From:</span></b><span lang=EN-US style='font-size:10.0pt;
font-family:"Tahoma","sans-serif"'> powerh-l-bounces+ken.langendock=rogers.com@lists.sowder.com
[mailto:powerh-l-bounces+ken.langendock=rogers.com@lists.sowder.com] <b>On
Behalf Of </b>Dan Lambshead<br>
<b>Sent:</b> February 24, 2009 9:17 AM<br>
<b>To:</b> powerh-l@lists.sowder.com<br>
<b>Subject:</b> Sorting of null values in Powerhouse<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p>
<div>
<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt;font-family:"Arial","sans-serif"'>Hello,</span><span lang=EN-US><o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span lang=EN-US> <o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt;font-family:"Arial","sans-serif"'>
Does anyone know if there is an option to sort null values so that they appear
at the top (in Oracle, as they would if they were spaces, as previously we had
in indexed files) rather than the bottom. This is for OpenVMS and Powerhouse version
8.40.D1.</span><span lang=EN-US><o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt;font-family:"Arial","sans-serif"'>
Of course we could do a define, setting nulls to spaces and sort on that, but
still wondering if there is an easier way.</span><span lang=EN-US><o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span lang=EN-US> <o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt;font-family:"Arial","sans-serif"'>Thanks</span><span lang=EN-US><o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span lang=EN-US> <o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt;font-family:"Arial","sans-serif"'>Dan</span><span lang=EN-US><o:p></o:p></span></p>
</div>
<p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p>
<p><span lang=EN-US style='font-size:10.0pt'>No virus found in this incoming
message.<br>
Checked by AVG.<br>
Version: 7.5.552 / Virus Database: 270.11.3/1968 - Release Date: 23/02/2009
6:22 PM</span><span lang=EN-US><o:p></o:p></span></p>
<p class=MsoNormal><o:p> </o:p></p>
<p><span style='font-size:10.0pt'>No virus found in this outgoing message.<br>
Checked by AVG.<br>
Version: 7.5.552 / Virus Database: 270.11.3/1968 - Release Date: 23/02/2009
6:22 PM</span><o:p></o:p></p>
</div>
</DIV>
<DIV> </DIV>
<DIV>
<P CLASS="MsoNormal" STYLE="MARGIN: 0in 0in 0pt"><SPAN LANG="EN-GB" STYLE="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Arial"><FONT COLOR="gray">Registered No. 755780 England</FONT></SPAN></P>
<P CLASS="MsoNormal" STYLE="MARGIN: 0in 0in 0pt"><SPAN LANG="EN-GB" STYLE="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Arial"><FONT COLOR="gray">Registered Office: FM Insurance Company Limited</FONT></SPAN></P>
<P CLASS="MsoNormal" STYLE="MARGIN: 0in 0in 0pt"><SPAN LANG="EN-GB" STYLE="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Arial"><FONT COLOR="gray">1 Windsor Dials, Windsor,</FONT></SPAN></P>
<P CLASS="MsoNormal" STYLE="MARGIN: 0in 0in 0pt"><SPAN LANG="EN-GB" STYLE="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Arial"></SPAN><SPAN LANG="EN-GB" STYLE="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Arial"><FONT COLOR="gray">Berkshire, UK, SL4 1RS</FONT></SPAN></P>
<P CLASS="MsoNormal" STYLE="MARGIN: 0in 0in 0pt"><SPAN LANG="EN-GB" STYLE="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Arial"><FONT COLOR="gray">Regulated by the Financial Services Authority.</FONT></SPAN></P>
<P CLASS="MsoNormal" STYLE="MARGIN: 0in 0in 0pt"><SPAN LANG="EN-GB" STYLE="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Arial"><FONT COLOR="gray">VAT No. G.B.: 792 4276 02</FONT></SPAN></P></DIV></BODY></HTML>