<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Stupid question about Primary and Secondary</TITLE>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.6000.16544" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=424044703-14112007><FONT face=Arial
color=#0000ff size=2>There is no way currently to do what you want. I requested
an enhancement with Cognos to add a "REQUIRED" option to a secondary file to do
this.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=424044703-14112007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=424044703-14112007><FONT face=Arial
color=#0000ff size=2>Until then Hard code the find and comment out the OPTIONAL
on the secondary GET</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=424044703-14112007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=424044703-14112007><FONT face=Arial
color=#0000ff size=2>Ken</FONT></SPAN></DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B>
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>fernando.olmos@hpa.com.au<BR><B>Sent:</B> November 13, 2007 7:28
PM<BR><B>To:</B> powerh-l@lists.sowder.com<BR><B>Subject:</B> Stupid question
about Primary and Secondary<BR></FONT><BR></DIV>
<DIV></DIV><!-- Converted from text/rtf format -->
<P><FONT face=Arial size=2>I thought that the following code would make the
ORDER_MASTER table *not* optional!</FONT> </P>
<P><FONT face=Arial size=2>> screen ert</FONT> <BR><FONT face=Arial
size=2>> file customers in isdb</FONT> <BR><FONT face=Arial size=2>> file
order_master in isdb secondary</FONT> <BR><FONT face=Arial size=2>> build
list detail</FONT> </P>
<P><FONT face=Arial size=2>> PROCEDURE PATH</FONT> <BR><FONT face=Arial
size=2>> BEGIN</FONT> <BR><FONT face=Arial
size=2>> LET PATH = 1</FONT> <BR><FONT face=Arial
size=2>> END</FONT> <BR><FONT face=Arial size=2>>
PROCEDURE FIND</FONT> <BR><FONT face=Arial size=2>> BEGIN</FONT>
<BR><FONT face=Arial size=2>> GET CUSTOMERS
SEQUENTIAL</FONT> <BR><FONT face=Arial size=2>> GET
ORDER_MASTER OPTIONAL</FONT> <BR><FONT face=Arial
size=2>> END</FONT> </P>
<P><FONT face=Arial size=2>Yet it does. Why?</FONT> </P>
<P><FONT face=Arial size=2>How can I declare the FILE statement to not place an
OPTIONAL on GET ORDER_MASTER?</FONT> </P>
<P><FONT face=Arial size=2>Thanks</FONT> </P>
<P><FONT face=Arial color=#0000ff size=2>Kind regards,</FONT> </P>
<P><FONT face="Courier New" size=2>---</FONT> <BR><SPAN lang=en-au><B><FONT
face=Arial size=2>Fernando Olmos</FONT></B></SPAN> <BR><SPAN lang=en-au><FONT
face=Arial color=#808080 size=2>Senior Analyst Programmer</FONT></SPAN>
<BR><SPAN lang=en-au><B><FONT face=Arial color=#000080 size=2>HPA</FONT> <FONT
face=Arial color=#0000ff size=2>– A Salmat Company</FONT></B><BR><FONT
face=Arial color=#808080 size=2>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 face=Arial
color=#0000ff size=2>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>