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