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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / column	Type	Description & values	Updated by
#`UGP-SYSTEM` PK SYSTEM	Alpha 2	—	UG00.1, UG00.2, UG00.4, UG99.1, UG99.2, UG99.6, UG99.8, XSYS.1 +1 more
#`UGP-RELEASE` PK RELEASE	Numeric 2	—	UG00.1, UG00.2, UG00.4, UG99.1, UG99.2, UG99.6, UG99.8, XSYS.1 +1 more
#`UGP-REL-LEVEL` PK REL_LEVEL	Numeric 2	—	UG00.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 6	—	UG00.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 are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`UGPSET1`	`SYSTEM` `RELEASE` `REL-LEVEL` `KEY1` `KEY2` `KEY3` `KEY4` `KEY5` `KEY6` `KEY7` `KEY8` `SEQ-NUMBER`	Primary		UG00.1, UG00.2, UG00.3, UG00.4, UG95.1, UG95.3, UG95.4, UG99.1 +13 more

Programs

Updated by (10)

UG00.1 Upgrade Setup
UG00.2 Advanced Setup
UG00.3 Upgrade Setup - Database Connectivity
UG00.4 Backup/Clear/Restore Setup Data
UG99.1 Upgrade Menu
UG99.2 Main Screen
UG99.6 Utilities
UG99.8 Job Info Edit
XSYS.1 System Call
XUGP.2 Suite definitions

Referenced by (7)

UG95.1 Upgrade Status
UG95.3 Clear Statistics
UG95.4 File Statistics
UG990 Submit REORG
UG991 Submit Java program
XJOB.1 Definition Screen
XUGS.1 Ugstat Maintenance

UGPARAM – Upgrade Parameter

About UGPARAM

Fields (13) Copy as SQL

Indexes (1)

Programs

Updated by (10)

Referenced by (7)

Fields (13)