<html>
<head>
<style>
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
FONT-SIZE: 10pt;
FONT-FAMILY:Tahoma
}
</style>
</head>
<body class='hmmessage'>
Hi Patrick:<BR>
<BR> I suspect you can say <BR>
<BR>
QDESIGN UPDATE=TOPDOWN<BR>
or QDESIGN UPDATE=BOTTOMUP<BR>
<BR>
<B><FONT face=BellGothic-Black size=3><BR>
<P align=left>Bottomup: Default Order of PUT Verb Generation</P></FONT><FONT face=SabonLTStd-Bold size=2>
<P align=left>1. </B></FONT><FONT face=SabonLTStd-Roman size=2>Generate SECONDARY files that occur with the DETAIL file</P></FONT><B><FONT face=SabonLTStd-Bold size=2>
<P align=left>2. </B></FONT><FONT face=SabonLTStd-Roman size=2>Generate DELETE files that occur with the DETAIL file</P></FONT><B><FONT face=SabonLTStd-Bold size=2>
<P align=left>3. </B></FONT><FONT face=SabonLTStd-Roman size=2>Generate the DETAIL file</P></FONT><B><FONT face=SabonLTStd-Bold size=2>
<P align=left>4. </B></FONT><FONT face=SabonLTStd-Roman size=2>Generate SECONDARY files that occur with or are related to the PRIMARY file</P></FONT><B><FONT face=SabonLTStd-Bold size=2>
<P align=left>5. </B></FONT><FONT face=SabonLTStd-Roman size=2>Generate DELETE files that do not occur with the DETAIL file</P></FONT><B><FONT face=SabonLTStd-Bold size=2>
<P align=left>6. </B></FONT><FONT face=SabonLTStd-Roman size=2>Generate the PRIMARY file</P></FONT><B><FONT face=SabonLTStd-Bold size=2>
<P align=left>7. </B></FONT><FONT face=SabonLTStd-Roman size=2>Generate MASTER files that occur with the PRIMARY file</P></FONT><B><FONT face=SabonLTStd-Bold size=2>
<P align=left>8. </B></FONT><FONT face=SabonLTStd-Roman size=2>Generate MASTER files that do not occur with the PRIMARY file</P></FONT><B><FONT face=SabonLTStd-Bold size=2>
<P align=left>9. </B></FONT><FONT face=SabonLTStd-Roman size=2>Generate standalone AUDIT files</P></FONT><B><FONT face=BellGothic-Black size=3>
<P align=left>Topdown: 7.10 Order of PUT Verb Generation (OpenVMS)</P></B></FONT><FONT face=SabonLTStd-Roman size=2>
<P align=left>This is the order of PUT verb generation on OpenVMS in version 7.10 and before.</P></FONT><B><FONT face=SabonLTStd-Bold size=2>
<P align=left>1. </B></FONT><FONT face=SabonLTStd-Roman size=2>Generate Master files</P></FONT><B><FONT face=SabonLTStd-Bold size=2>
<P align=left>2. </B></FONT><FONT face=SabonLTStd-Roman size=2>Generate the Primary file</P></FONT><B><FONT face=SabonLTStd-Bold size=2>
<P align=left>3. </B></FONT><FONT face=SabonLTStd-Roman size=2>Generate the Detail file and Secondary files</P></FONT><B><FONT face=SabonLTStd-Bold size=2>
<P align=left>4. </B></FONT><FONT face=SabonLTStd-Roman size=2>Generate Delete files</P></FONT><B><FONT face=SabonLTStd-Bold size=2>
<P align=left>5. </B></FONT><FONT face=SabonLTStd-Roman size=2>Generate stand-alone Audit Files</FONT></P>
<P align=left><FONT face=SabonLTStd-Roman size=2></FONT> </P>
<P align=left>Note: Oracle/RDB has DEFERRED constraint ability which </P>
<P align=left>allows you more freedom as to the order of PUT verbs.</P>
<P align=left>The lowest level where this is COMMIT ON NEXT PRIMARY. That is</P>
<P align=left>becuse if you are using COMMIT ON UPDATE the contraint will </P>
<P align=left>immediately fire.</P>
<P align=left> </P><FONT face=SabonLTStd-Roman size=2><B><FONT face=SabonLTStd-Bold size=2>
<P align=left>COMMIT ON NEXT PRIMARY</P></B></FONT><FONT face=SabonLTStd-Roman size=2>
<P align=left>Use this option if you want to group all detail records (perhaps requiring several</P>
<P align=left>entry or display screens) together with primary and secondary records and treat</P>
<P align=left>them as a unit to be committed or rolled back. Locally active transactions are</P>
<P align=left>committed: when the user starts an entry sequence (before the PREENTRY</P>
<P align=left>procedure); when the user retrieves the next set of primary records (before the</P>
<P align=left>FIND procedure); and when the user exits the screen (before and after the EXIT</P>
<P align=left>procedure).</P></FONT>
</FONT><BR> <BR>
<BLOCKQUOTE>
<HR>
Subject: Migration to PWH 8.40e<BR>Date: Thu, 13 Dec 2007 12:31:41 +0100<BR>From: PATRICK.DEMEULENAERE@agceurope.com<BR>To: powerh-l@lists.sowder.com<BR><BR>
<META content="Microsoft SafeHTML" name=Generator>
<SPAN lang=fr-be><FONT face=Tahoma color=#008080 size=2>Hello,</FONT></SPAN> <BR>
<SPAN lang=fr-be><FONT face=Tahoma color=#008080 size=2>We are busy preparing the migration from 7.10g to 8.40e. We are working with OpenVMS on Alpha server</FONT></SPAN> <BR>
<SPAN lang=fr-be><FONT face=Tahoma color=#008080 size=2>In the manual "Differences between versions 7.10 and 8.30 we found in the chapter "Update Procedure Program Parameter"</FONT></SPAN> <BR>
<SPAN lang=fr-be><FONT face=Tahoma color=#008080 size=2>That the order of code generation has changed in 840e. If you want to keep the order as in 710g we should use the program parameter UPDATE</FONT></SPAN><BR>
<SPAN lang=fr-be><FONT face=Tahoma color=#008080 size=2>with the option TOPDOWN/BOTTOMUP</FONT></SPAN> <BR>
<SPAN lang=fr-be><FONT face=Tahoma color=#008080 size=2>Can someone give me the syntax of this parameter ?</FONT></SPAN> <BR>
<SPAN lang=fr-be><FONT face=Tahoma color=#008080 size=2>Thanks,</FONT></SPAN><SPAN lang=en-us></SPAN> <BR>
<B><I><SPAN lang=en-gb><FONT face="Monotype Corsiva" color=#008080>Patrick</FONT></SPAN></I></B> <BR>
<SPAN lang=fr-be><FONT face=Arial color=#008080 size=2>Patrick De Meulenaere</FONT></SPAN> <BR><SPAN lang=fr-be><FONT face=Arial color=#008080 size=2>AGC Europe IT </FONT></SPAN><BR><SPAN lang=fr-be><FONT face=Arial color=#008080 size=2>Powerhouse Development center</FONT></SPAN> <BR><BR>
<TABLE>
<TBODY>
<TR>
<TD bgColor=#ffffff><FONT color=#000000>This message is CONFIDENTIAL unless otherwise specified (http://www.agceurope.net/email_confidentiality.html).<BR></FONT></TD></TR></TBODY></TABLE></BLOCKQUOTE><br /><hr />HO HO HO, if you've been nice this year, email Santa! <a href='http://asksanta.ca/?icid=SANTAENCA005' target='_new'>Visit asksanta.ca to learn more!</a></body>
</html>