<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Verdana
}
--></style>
</head>
<body class='hmmessage'>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"><meta name="ProgId" content="Word.Document"><meta name="Generator" content="Microsoft Word 11"><meta name="Originator" content="Microsoft Word 11"><link rel="File-List" href="file:///C:%5CDOCUME%7E1%5CADMINI%7E1%5CLOCALS%7E1%5CTemp%5Cmsohtml1%5C01%5Cclip_filelist.xml"><!--[if gte mso 9]><xml>
<w:WordDocument>
<w:View>Normal</w:View>
<w:Zoom>0</w:Zoom>
<w:PunctuationKerning/>
<w:ValidateAgainstSchemas/>
<w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid>
<w:IgnoreMixedContent>false</w:IgnoreMixedContent>
<w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText>
<w:Compatibility>
<w:BreakWrappedTables/>
<w:SnapToGridInCell/>
<w:WrapTextWithPunct/>
<w:UseAsianBreakRules/>
<w:DontGrowAutofit/>
</w:Compatibility>
<w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel>
</w:WordDocument>
</xml><![endif]--><!--[if gte mso 9]><xml>
<w:LatentStyles DefLockedState="false" LatentStyleCount="156">
</w:LatentStyles>
</xml><![endif]--><style>
<!--
/* Font Definitions */
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;
mso-font-charset:0;
mso-generic-font-family:swiss;
mso-font-pitch:variable;
mso-font-signature:536871559 0 0 0 415 0;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{mso-style-parent:"";
margin:0in;
margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:12.0pt;
font-family:"Times New Roman";
mso-fareast-font-family:"Times New Roman";}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;
mso-header-margin:.5in;
mso-footer-margin:.5in;
mso-paper-source:0;}
div.Section1
{page:Section1;}
-->
</style><!--[if gte mso 10]>
<style>
/* Style Definitions */
table.MsoNormalTable
{mso-style-name:"Table Normal";
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-parent:"";
mso-padding-alt:0in 5.4pt 0in 5.4pt;
mso-para-margin:0in;
mso-para-margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:10.0pt;
font-family:"Times New Roman";
mso-ansi-language:#0400;
mso-fareast-language:#0400;
mso-bidi-language:#0400;}
</style>
<![endif]-->
<p class="MsoNormal"><span style="font-size: 10pt; font-family: Verdana;">Hi All: <br></span></p><p class="MsoNormal"><span style="font-size: 10pt; font-family: Verdana;"><br></span></p><p class="MsoNormal"><span style="font-size: 10pt; font-family: Verdana;">
My idea is the reverse of the technique where you remove the optional<br>
from the get of the secondary to display only those primary
records which have a <br>
corresponding secondary file. A failed get on a non optional
secondary raises<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size: 10pt; font-family: Verdana;"><span style=""> </span><span style=""> </span><span style=""> </span>an error condition.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size: 10pt; font-family: Verdana;"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size: 10pt; font-family: Verdana;"><span style=""> </span>An error in the FIND sequence goes back to
the next primary record if there is one<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size: 10pt; font-family: Verdana;"><span style=""> </span><span style=""> </span>otherwise back to the action field.<br>
<br>
From:- http://public.dhe.ibm.com/software/data/cognos/documentation<br>
/docs/en/powerhouse/8.4g/QD.pdf<br>
<br>
"Error Handling in the FIND Procedure<br>
If an error occurs during the execution of this procedure, <br>
QUICK backs up to the last GET verb for the PRIMARY file. <br>
If no such verb exists, QUICK prompts the screen user in the
Action field,<br>
without displaying any retrieved data."</span></p><p class="MsoNormal"><span style="font-size: 10pt; font-family: Verdana;"><br>
</span></p><p class="MsoNormal"> For example:-<br><span style="font-size: 10pt; font-family: Verdana;"></span></p><p class="MsoNormal"><br><span style="font-size: 10pt; font-family: Verdana;">
</span></p><p class="MsoNormal"><span style="font-size: 10pt; font-family: Verdana;"> file apmisumi<br>
select if source-code = "632654450"
and gm-part <> " 12844161" &<br>
and (flag-905="P" or flag-905="C") <br>
<br>
file apmisumi secondary alias bad_part <br>
access via </span><span style="font-size: 10pt; font-family: Arial;">APMISUMI-KEY &</span><span style="font-size: 10pt; font-family: Verdana;"><br>
</span><span style="font-size: 10pt; font-family: Arial;"> using
doc-char +"632654450" + " 12844161" </span><span style="font-size: 10pt; font-family: Verdana;"><br>
<br>
<br>
</span><span style="font-size: 10pt; font-family: Arial;">
Procedure Find</span><span style="font-size: 10pt; font-family: Verdana;"><br>
</span><span style="font-size: 10pt; font-family: Arial;">
Begin</span><span style="font-size: 10pt; font-family: Verdana;"><br>
</span><span style="font-size: 10pt; font-family: Arial;">
Get apmisumi</span><span style="font-size: 10pt; font-family: Verdana;"><br>
</span><span style="font-size: 10pt; font-family: Arial;">
Get bad_part optional</span><span style="font-size: 10pt; font-family: Verdana;"><br>
</span><span style="font-size: 10pt; font-family: Arial;"> If
NOT NEWRECORD of bad_part</span><span style="font-size: 10pt; font-family: Verdana;"><br>
</span><span style="font-size: 10pt; font-family: Arial;"> then
error " "</span><span style="font-size: 10pt; font-family: Verdana;"><br>
</span><span style="font-size: 10pt; font-family: Arial;">
End</span><span style="font-size: 10pt; font-family: Verdana;"><br>
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size: 10pt; font-family: Verdana;"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size: 10pt; font-family: Verdana;">Jay tried
it and got it working. Good work, Jay!</span></p><p class="MsoNormal"><br><span style="font-size: 10pt; font-family: Verdana;"></span></p><p class="MsoNormal"><span style="font-size: 10pt; font-family: Verdana;">Regards, <br></span></p>Peter<br><font size="1" color="Gray" face="Arial"><br>
</font> <br /><hr />Don't miss a beat <a href='http://go.microsoft.com/?linkid=9712961' target='_new'>Get Messenger on your phone</a></body>
</html>