migration to PWH 8.40e
De Meulenaere Patrick
PATRICK.DEMEULENAERE at agceurope.com
Fri Dec 14 09:31:33 CST 2007
Thank you Peter
We solved it by adding UPDATE ORDER TOP DOWN in file PH.RS
Patrick
-----Original Message-----
From:
powerh-l-bounces+patrick.demeulenaere=agceurope.com at lists.sowder.com
[mailto:powerh-l-bounces+patrick.demeulenaere=agceurope.com at lists.sowder
.com] On Behalf Of powerh-l-request at lists.sowder.com
Sent: vrijdag 14 december 2007 16:27
To: powerh-l at lists.sowder.com
Subject: powerh-l Digest, Vol 31, Issue 8
Send powerh-l mailing list submissions to
powerh-l at lists.sowder.com
To subscribe or unsubscribe via the World Wide Web, visit
http://lists.sowder.com/mailman/listinfo/powerh-l
or, via email, send a message with subject or body 'help' to
powerh-l-request at lists.sowder.com
You can reach the person managing the list at
powerh-l-owner at lists.sowder.com
When replying, please edit your Subject line so it is more specific
than "Re: Contents of powerh-l digest..."
Today's Topics:
1. RE:Migration to PWH 8.40e (Peter Bateman)
2. Problem With Subfiles: Automatic Realignment of ITEMS
(vamsi krishna)
----------------------------------------------------------------------
Message: 1
Date: Thu, 13 Dec 2007 18:03:03 -0400
From: Peter Bateman <peterbateman808 at hotmail.com>
Subject: RE: Migration to PWH 8.40e
To: De Meulenaere Patrick <patrick.demeulenaere at agceurope.com>,
<powerh-l at lists.sowder.com>
Message-ID: <BAY133-W378CAA3C7938F722CEAB0CF9660 at phx.gbl>
Content-Type: text/plain; charset="iso-8859-1"
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-0001.html
------------------------------
Message: 2
Date: Fri, 14 Dec 2007 20:50:44 +0530
From: "vamsi krishna" <vamsi.coe at gmail.com>
Subject: Problem With Subfiles: Automatic Realignment of ITEMS
To: powerh-l at lists.sowder.com
Message-ID:
<6fa629b40712140720s1e0a6704v2825c71b4a167662 at mail.gmail.com>
Content-Type: text/plain; charset="iso-8859-1"
Hello All,
I've problems while creating system interfaces using subfiles.
Subfile definition looks something like this:
DEFINE REC-ID CHAR*4 = "0010"
DEFINE CHARGES CHAR*14 = ""
DEFINE C-LLC CHAR*14 = **something
DEFINE C-LCC CHAR*14 = **something
DEFINE C-PSX CHAR*2 = **something
DEFINE C-PCD CHAR*3 = **something
DEFINE C-UNT CHAR*8 = **something
DEFINE RECORD-DAS CHAR*183 = DEK OF NS-RECORD +
&
BNI OF PD-RECORD +
&
MULT$S_OF_PTS OF NS-RECORD +
&
CHARGES +
&
C-LLC +
&
C-LCC +
&
FRA OF NS-RECORD +
&
C-PSX +
&
C-PCD +
&
ESG OF NS-RECORD +
&
C-UNT +
&
WCP OF NS-RECORD +
&
WC2 OF NS-RECORD +
&
PST OF NS-RECORD +
&
MAS OF CB-RECORD +
&
CUM OF CB-RECORD
DEFINE NLSVINT CHAR*1= "N" IF NLSR$S_OF_PTS OF NS-RECORD = "N" ELSE "Y"
SUBFILE $PIC_DATA/OPNLSVINT1 KEEP
&
INCLUDE REC-ID,
&
PRN OF NS-RECORD,
&
CAT OF NS-RECORD,
&
MER OF NS-RECORD,
&
RECORD-DAS,
&
NLSVINT &
INDEX PRN UNIQUE
&
SEGMENT PRN
When I create this subfile for the first time, sho item command
displays:
REC-ID CHAR X(4)
* PRN CHAR X(12)
CAT CHAR X(12)
MER CHAR X(12)
RECORD-DAS CHAR X(183)
NLSVINT CHAR X(1)
In the first run, to compare data of previous day, we create one more
subfile:
ACCESS *$PIC_DATA/OPNLSVINT1
SELECT IF REC-ID <> REC-ID
SUBFILE $PIC_DATA/OPNLSVINT2 KEEP APPEND &
INCLUDE OPNLSVINT1 &
INDEX PRN UNIQUE &
SEGMENT PRN
At the end of job execution it renames OPNLSVINT1 to OPNLSVINT2 (
.dat,.sfd,.idx ) and creates OPNLSVINT1 next day with comparison with
OPNLSVINT2 of previous day.
And when I run the job again...., and the do a sho ite command, it
displays:
OPNLSVINT2 TYPE SCALE SCALE DEC PICTURE
REC-ID CHAR X(4)
* PRN CHAR X(12)
CAT CHAR X(12)
MER CHAR X(12)
NLSVINT CHAR X(1)
RECORD-DAS CHAR X(183)
As you the single character flag precedes the 183 character item now..
which
automatically changes the Layout(data in output).
Could anyone provide any comment/hints to fix this?
Sorry if I'm spamming your mail box. :-)
Thanks in advance.
Regards,
Vamsi
--
"Nothing is impossible as impossible itself says i m possible"
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://lists.sowder.com/pipermail/powerh-l/attachments/20071214/0f46139b
/attachment.html
------------------------------
--
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l at lists.sowder.com
Subscribe: "subscribe" in message body to
powerh-l-request at lists.sowder.com
Unsubscribe: "unsubscribe <password>" in message body to
powerh-l-request at lists.sowder.com
http://lists.sowder.com/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.
Add 'site:lists.sowder.com powerh-l' to your search terms to search the
list archive at Google.
End of powerh-l Digest, Vol 31, Issue 8
***************************************
This message is CONFIDENTIAL unless otherwise specified (http://www.agceurope.net/email_confidentiality.html).
More information about the powerh-l
mailing list