<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META NAME="Generator" CONTENT="MS Exchange Server version 6.0.6619.12">
<TITLE>Stupid question about Primary and Secondary</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->
<P><FONT SIZE=2 FACE="Arial">I thought that the following code would make the ORDER_MASTER table *not* optional!</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">> screen ert</FONT>
<BR><FONT SIZE=2 FACE="Arial">> file customers in isdb</FONT>
<BR><FONT SIZE=2 FACE="Arial">> file order_master in isdb secondary</FONT>
<BR><FONT SIZE=2 FACE="Arial">> build list detail</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">> PROCEDURE PATH</FONT>
<BR><FONT SIZE=2 FACE="Arial">> BEGIN</FONT>
<BR><FONT SIZE=2 FACE="Arial">> LET PATH = 1</FONT>
<BR><FONT SIZE=2 FACE="Arial">> END</FONT>
<BR><FONT SIZE=2 FACE="Arial">> PROCEDURE FIND</FONT>
<BR><FONT SIZE=2 FACE="Arial">> BEGIN</FONT>
<BR><FONT SIZE=2 FACE="Arial">> GET CUSTOMERS SEQUENTIAL</FONT>
<BR><FONT SIZE=2 FACE="Arial">> GET ORDER_MASTER OPTIONAL</FONT>
<BR><FONT SIZE=2 FACE="Arial">> END</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">Yet it does. Why?</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">How can I declare the FILE statement to not place an OPTIONAL on GET ORDER_MASTER?</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">Thanks</FONT>
</P>
<P><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">Kind regards,</FONT>
</P>
<P><FONT SIZE=2 FACE="Courier New">---</FONT>
<BR><SPAN LANG="en-au"><B><FONT SIZE=2 FACE="Arial">Fernando Olmos</FONT></B></SPAN>
<BR><SPAN LANG="en-au"><FONT COLOR="#808080" SIZE=2 FACE="Arial">Senior Analyst Programmer</FONT></SPAN>
<BR><SPAN LANG="en-au"><B><FONT COLOR="#000080" SIZE=2 FACE="Arial">HPA</FONT> <FONT COLOR="#0000FF" SIZE=2 FACE="Arial">– A Salmat Company</FONT></B><BR>
<FONT COLOR="#808080" SIZE=2 FACE="Arial">Direct: 02 9311 5411<BR>
Fax: 02 9311 5166<BR>
Mobile: 0434 879 784</FONT></SPAN>
<BR><SPAN LANG="en-au"></SPAN><A HREF="outbind://72-000000004873297C6F02D34791376BCD02053396070089F66260EA86FC45B9843CB9AE160C240000003C72B40000B1FC7253EE1378408169587124093AAC000000660A050000/www.hpa.com.au"><SPAN LANG="en-au"><U></U><U><B></B></U><U><B></B></U><U><B><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">www.hpa.com.au</FONT></B></U></SPAN></A><SPAN LANG="en-au"></SPAN>
</P>
<BR>
<pre>**********************************************************************
IMPORTANT
The contents of this e-mail and its attachments are confidential and intended
solely for the use of the individual or entity to whom they are addressed. If
you received this e-mail in error, please notify the HPA Postmaster, postmaster@hpa.com.au,
then delete the e-mail.
This footnote also confirms that this e-mail message has been swept for the
presence of computer viruses by Ironport. Before opening or using any
attachments, check them for viruses and defects.
Our liability is limited to resupplying any affected attachments.
HPA collects personal information to provide and market our services. For more
information about use, disclosure and access see our Privacy Policy at
www.hpa.com.au
**********************************************************************
</pre></BODY>
</HTML>