Migration to PWH 8.40e

Peter Bateman peterbateman808 at hotmail.com
Thu Dec 13 16:03:03 CST 2007


        Hi Patrick:
            I suspect you can say 
 
            QDESIGN UPDATE=TOPDOWN
       or  QDESIGN UPDATE=BOTTOMUP
 
            
Bottomup: Default Order of PUT Verb Generation
1. Generate SECONDARY files that occur with the DETAIL file
2. Generate DELETE files that occur with the DETAIL file
3. Generate the DETAIL file
4. Generate SECONDARY files that occur with or are related to the PRIMARY file
5. Generate DELETE files that do not occur with the DETAIL file
6. Generate the PRIMARY file
7. Generate MASTER files that occur with the PRIMARY file
8. Generate MASTER files that do not occur with the PRIMARY file
9. Generate standalone AUDIT files
Topdown: 7.10 Order of PUT Verb Generation (OpenVMS)
This is the order of PUT verb generation on OpenVMS in version 7.10 and before.
1. Generate Master files
2. Generate the Primary file
3. Generate the Detail file and Secondary files
4. Generate Delete files
5. Generate stand-alone Audit Files
 
Note: Oracle/RDB has DEFERRED constraint ability which 
allows you more freedom as to the order of PUT verbs.
The lowest level where this is COMMIT ON NEXT PRIMARY. That is
becuse if you are using COMMIT ON UPDATE the contraint will 
immediately fire.
 
COMMIT ON NEXT PRIMARY
Use this option if you want to group all detail records (perhaps requiring several
entry or display screens) together with primary and secondary records and treat
them as a unit to be committed or rolled back. Locally active transactions are
committed: when the user starts an entry sequence (before the PREENTRY
procedure); when the user retrieves the next set of primary records (before the
FIND procedure); and when the user exits the screen (before and after the EXIT
procedure).
 


Subject: Migration to PWH 8.40eDate: Thu, 13 Dec 2007 12:31:41 +0100From: PATRICK.DEMEULENAERE at agceurope.comTo: powerh-l at lists.sowder.com

Hello, 
We are busy preparing the migration from 7.10g to 8.40e. We are working with OpenVMS on Alpha server 
In the manual "Differences between versions 7.10 and 8.30 we found  in the chapter "Update Procedure Program Parameter" 
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
with the option TOPDOWN/BOTTOMUP 
Can someone give me the syntax of this parameter ? 
Thanks, 
Patrick 
Patrick De Meulenaere AGC Europe IT Powerhouse Development center 



This message is CONFIDENTIAL unless otherwise specified (http://www.agceurope.net/email_confidentiality.html).
_________________________________________________________________
Use fowl language with Chicktionary. Click here to start playing!
http://puzzles.sympatico.msn.ca/chicktionary/index.html?icid=htmlsig
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20071213/2a592c66/attachment.html


More information about the powerh-l mailing list