UGPARAM – Upgrade Parameter

System
Upgrade Module (UG)
Prefix
UGP
Primary key
SYSTEM, RELEASE, REL-LEVEL, KEY1, KEY2, KEY3, KEY4, KEY5, KEY6, KEY7, KEY8, SEQ-NUMBER
Fields
13
Updated by
10 programs
Referenced by
7 programs

UGPARAM is the Upgrade Parameter table in Lawson Upgrade Module (prefix UGP). It is indexed by SYSTEM, RELEASE, REL-LEVEL, KEY1, KEY2, KEY3, KEY4, KEY5, KEY6, KEY7, KEY8, SEQ-NUMBER (UGPSET1). It is updated by UG00.1, UG00.2, UG00.3, UG00.4, UG99.1, UG99.2, UG99.6, UG99.8 and 2 more and referenced by UG95.1, UG95.3, UG95.4, UG990, UG991, XJOB.1 and XUGS.1. The table has 13 fields, 1 index and 0 documented relations.

About UGPARAM

The upgrade parameter file is a front end file used for loading default information into the target ("to") upgrade system.

Fields (13)

Column = COBOL field name without the UGP- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
UGP-SYSTEM PK
SYSTEM
Alpha 2UG00.1, UG00.2, UG00.4, UG99.1, UG99.2, UG99.6, UG99.8, XSYS.1 +1 more
UGP-RELEASE PK
RELEASE
Numeric 2UG00.1, UG00.2, UG00.4, UG99.1, UG99.2, UG99.6, UG99.8, XSYS.1 +1 more
UGP-REL-LEVEL PK
REL_LEVEL
Numeric 2UG00.1, UG00.2, UG00.4, UG99.1, UG99.2, UG99.6, UG99.8, XSYS.1 +1 more
UGP-KEY1 PK
KEY1
Alpha 10 (Lower Case)UG00.1, UG00.2, UG00.4, UG99.1, UG99.2, UG99.6, UG99.8, XSYS.1 +1 more
UGP-KEY2 PK
KEY2
Alpha 10 (Lower Case)UG00.1, UG00.2, UG00.4, UG99.1, UG99.2, UG99.6, UG99.8, XSYS.1 +1 more
UGP-KEY3 PK
KEY3
Alpha 10 (Lower Case)UG00.1, UG00.2, UG00.4, UG99.1, UG99.2, UG99.6, UG99.8, XSYS.1 +1 more
UGP-KEY4 PK
KEY4
Alpha 10 (Lower Case)UG00.1, UG00.2, UG00.4, UG99.1, UG99.2, UG99.6, UG99.8, XSYS.1 +1 more
UGP-KEY5 PK
KEY5
Alpha 10 (Lower Case)UG00.1, UG00.2, UG00.4, UG99.1, UG99.2, UG99.6, UG99.8, XSYS.1 +1 more
UGP-KEY6 PK
KEY6
Alpha 10 (Lower Case)UG00.1, UG00.2, UG00.4, UG99.1, UG99.2, UG99.6, UG99.8, XSYS.1 +1 more
UGP-KEY7 PK
KEY7
Alpha 10 (Lower Case)UG00.1, UG00.2, UG00.4, UG99.1, UG99.2, UG99.6, UG99.8, XSYS.1 +1 more
UGP-KEY8 PK
KEY8
Alpha 10 (Lower Case)UG00.1, UG00.2, UG00.4, UG99.1, UG99.2, UG99.6, UG99.8, XSYS.1 +1 more
UGP-SEQ-NUMBER PK
SEQ_NUMBER
Numeric 6UG00.1, UG00.2, UG00.4, UG99.1, UG99.2, UG99.6, UG99.8, XSYS.1 +1 more
UGP-DATA
DATA
Alpha 500 (Lower Case)UG00.1, UG00.2, UG00.4, UG99.1, UG99.6, UG99.8, XSYS.1, XUGP.2

Indexes (1)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
UGPSET1SYSTEM, RELEASE, REL-LEVEL, KEY1, KEY2, KEY3, KEY4, KEY5, KEY6, KEY7, KEY8, SEQ-NUMBERPrimaryUG00.1, UG00.2, UG00.3, UG00.4, UG95.1, UG95.3, UG95.4, UG99.1 +13 more

Programs

Updated by (10)

Referenced by (7)