Appendix B: Reference

This appendix contains reference information you need to install APS for z/OS.

APS@PROC CLIST

You execute the APS@PROC CLIST to install the APS ISPF panels that support APS components and APS program generation. The APS ISPF panels consist of an APS Main Menu panel and other APS-supplied ISPF panels. When you execute the APS@PROC CLIST, you are prompted for the information you supplied on the Pre-Installation Checklist for concatenating the APS libraries to your ISPF libraries.

The APS@PROC CLIST builds:

A project-related CLIST in the &DSNPRE.CLIST data set APS5000
A logon PROC named APS5000 in the &DSNPRE.ISPSLIB
An ISPF panel named APS5000 in &DSNPRE.GENPANEL

Install APS@PROC as follows.

Copy the unloaded &APSPRE.CLIST(APS40SYS) and rename it APS5000 in your TSO system CLIST library.
Execute the APS@PROC CLIST.
After the APS@PROC CLIST has successfully executed, optionally copy the logon PROC, &DSNPRE.ISPSLIB(APS5000) to your system PROCLIB.

The location of APS5000 determines the value of the REALLOC keyword, and vice versa, as follows.

If APS5000 resides in	The REALLOC keyword is set to
Logon Proclib	LOGON
System CLIST Library	YES
&DSNPRE.CLIST	NO

The keyword is set to LOGON (initial mode) when it is invoked from the APS 5000 logon PROC you copied to the system PROCLIB for each project. When the keyword is set to LOGON, the APS5000 CLIST reallocates only the ISPF profile library, because the APS work files, PDSs, and ISPF libraries are allocated in the APS5000 logon PROC.

When the REALLOC keyword is set to YES, APS work files, PDSs, and ISPF libraries, including the profile dataset (ISPPROF), are allocated. When the REALLOC keyword is set to NO, no data sets are allocated; it is assumed that they were allocated when you logged onto APS through the logon PROC or the APS5000 CLIST in the system library. Thus, having gone back to READY after being in APS, you can get back into APS quickly (without reallocating datasets) by executing %APS5000.

To customize any of the above CLISTs or the logon PROC for a project, edit the corresponding file tailoring skeleton listed below before (re)executing APS@PROC for that project.

To customize	Edit
&DSNPRE.CLIST (APS5000)	&APSPRE.ISPSLIB (APS@CMD)
&DSNPRE.ISPSLIB (APS5000)	&APSPRE.ISPSLIB (APS@LGN)
&DSNPRE.GENPANEL (APS5000)	&APSPRE.ISPLIB (APS@PAN)

For example, if you want to change the concatenation order of the data sets allocated by APS, edit &APSPRE.ISPSLIB(APS@CMD) and &APSPRE.ISPSLIB(APS@LGN), and then re-execute APS@PROC.

Note: If any data sets on a ddname are VB, the first data set in the concatenation list must also be VB. The first data set must have the largest blocksize. Failure to follow these rules results in an 0C4 abend.

The APS5000 CLIST allocates APS work files and PDSs along with ISPF libraries. It then calls A2INIT00.

Note: You need to rebuild the APS5000 CLIST, panels, and logon PROC after you install APS and run the BUILD option from the APS Install Menu. Do this by selecting option 2 on the APS Project Dataset Configuration screen.

Access the Project Dataset Configuration screen as follows.

On the APS Main Menu, enter 4.2.1 in the Command field. The APS Administration screen displays.
On the APS Administration screen, select option 3, Project Dataset Configuration. The Project Dataset Configuration screen displays.
Caution: If you re-execute the APS@PROC CLIST, instead of using the Project Dataset Configuration option, the CLIST resets all values to the APS default values.

Overriding APS Default Values

APS@PROC calls A2INIT00, which brings up the APS@INST panel named APS5000 INSTALL MENU. From this panel, you can change the APS default values and the APS-supplied job cards.

Select each option on the APS5000 MENU that applies to your site and change the APS default values as desired. In particular, note that Option 10 - APS OPTIONS allows access to the following option override screens.
- APS BIND Options
- APS IDMS Options
- APS Job Control Cards
- APS Generator Options
- APS Precompiler Options
- APS Report Generator Options
For more information about the option screens, see the APS User's Guide chapter, Generate the Application.
Set the Override field on each screen to Yes. If any information is entered incorrectly, all fields automatically change to No. If the override field contains No, the APS-supplied defaults are used.
Change the supplied job cards J1 through J5. Option J - APS JOB CARDS displays the APS Job Control Cards screen.
The CLEAR option on this panel changes J1 through J5 to nulls. The SET option initializes J1 through J5 to the APS-supplied default values.

If you enter the following for J1
```
J1 ===> //&ZUSER.1 JOB (&SSMACCT),''&ZUSER'',
        // CLASS=&SSMCLASS, MSGCLASS=&SSMMCLAS,
        // MSGLEVEL=(0,0)
```
The job cards produced looks like this
```
//userid1 JOB  (9999),'userid',
// CLASS=A,MSGCLASS=X,
// MSGLEVEL=(0,0)
```
Select Option B (build) on the APS5000 INSTALL MENU to display the APS@INST CLIST. This CLIST builds the following data sets.
- APS5000 CLIST
- APS5000 Logon Proc
- APS5000 Panel (sets up default values for the APS PROFILE POOL)
  The Build option validates the information from the other APS Install screens. If an error is found, the short message in the upper right corner of the screen explains which option to check. When this happens, enter HELP or press PF1 to display the associated long message.
Enter END on the APS@INST panel. Control returns to APS@PROC, which invokes the APS5000 CLIST just built with the B(uild) Option.
APSMENU and APS5000 panels can be invoked from APS5000.

Reinstalling the Subschema Utilities

If you are upgrading your DB2 release or upgrading an existing release of APS and want to share your existing subschemas with the new release, follow these steps:

Note: If you are upgrading from an APS release prior to version 2.1.00, see the APS Technical bulletin "Installing APS for MVS SQL Suschema Utilities" in the Micro Focus SupportNet Knowledgebase.

Make a pre-installation check list. See See Pre-Installation Checklist.
Copy your previous job card member from the old &APSPRE.ISPSLIB to the new &APSPRE.ISPSLIB.
Perform See Step 1. Build Profile Variables.

Note: You must change the standard plan prefix name to avoid affecting the currently installed version of the utilities.
Perform See Step 2. Link the Utilities.
To rebind the APS Dynamic SQL processor, A1DPUTL, edit the data set &APSPRE.ISPSLIB(DB2SDYNM). Follow the directions for job card modification in DB2SDYNM.
Submit the job for execution.
Rebind the APS/SQL Subschema Utilities system software using the DB2SBIND member in &APSPRE.ISPSLIB.
If the plan prefix is changed, you can grant authorization for the new plans. Use the DB2SGRNT member in &ASPRE.ISPSLIB to execute grants for the Subschema Utilities. If using the EXPLAIN facility, perform "Step 8. Link EXPLAIN" and "Step 9. Bind EXPLAIN."

APS for z/OS Data Set Descriptions

Project Level Data Sets

Data Set Name	RECFM	LRECL	BLKSZ	Description
&DSNPRE.ACBLIB	U	0	6144	IMS ACB Library
&DSNPRE.AMSERV	FB	80	3120	Generated IDCAMS Source
&DSNPRE.APRAPPL	FB	80	3120	APSAPPL Application Static Data
&DSNPRE.APRPROG	FB	80	3120	APSPROG Program Static Data
&DSNPRE.APSSRC	FB	80	6160	APS Source Programs
&DSNPRE.APSAPPL	FB	80	6160	Painted Application Definitions
&DSNPRE.APSCNIO	FB	80	6160	Painted Scenarios
&DSNPRE.APSCNDT	FB	1	603040	Painted Scenarios
&DSNPRE.APSDATA	FB	80	6160	Painted Data Structures
&DSNPRE.APSDE	FB	240	6000	Data Element Library
&DSNPRE.APSEXPS	FB	80	6160	Online Express Save File
&DSNPRE.APSPROG	FB	80	6160	Painted Programs
&DSNPRE.APSREPT	FB	240	6000	Painted Report Mockups
&DSNPRE.APSSCFE	FB	80	3120	Field Edit Selection List
&DSNPRE.APSSCRN	FB	240	6000	Painted Screens
&DSNPRE.CLIST	FB	80	3120	User Customized CLISTs
&DSNPRE.CNTL	FB	80	3120	User Customized Control Cards
&DSNPRE.COBCICS	FB	80	6160	Generated COBOL (CICS programs)
&DSNPRE.COBPCCIC	FB	80	6160	Generated COBOL (CICS programs for PC)
&DSNPRE.COBPCIMS	FB	80	6160	Generated COBOL (IMS programs for PC)
&DSNPRE.COBIMS	FB	80	6160	Generated COBOL (IMS programs)
&DSNPRE.COBISPF	FB	80	6160	Generated COBOL (ISPF programs)
&DSNPRE.COBMVS	FB	80	6160	Generated COBOL (batch programs)
&DSNPRE.COBPC	FB	80	6160	Generated COBOL (batch for PC)
&DSNPRE.COPYLIB	FB	80	3120	COPYBOOKS
&DSNPRE.DBDLIB	U	0	6144	DBD Load Library
&DSNPRE.DBDSRC	FB	80	3120	DBD Source Library
&DSNPRE.DBRMLIB	FB	80	6160	DB2 DBRMLIB
&DSNPRE.DDIBKUP	FB	23	85950	Backup for DDIFILE
&DSNPRE.DDISRC	FB	80	3120	DDI Input Records
&DSNPRE.DDISYMB	FB	80	3120	Generated Database Macro Symbols
&DSNPRE.GEN5DLG	VB	136	3132	Generated ISPF Dialog panels (MOD5)
&DSNPRE.GENBMS	FB	80	3120	Generated BMS Source
&DSNPRE.GENDLG	FB	80	3120	Generated ISPF Dialog panels
&DSNPRE.GENPCBMS	FB	80	3120	Generated BMS Source for PC
&DSNPRE.GENPCMFS	FB	80	3120	Generated MFS Source for PC
&DSNPRE.GENMFS	FB	80	3120	Generated MFS Source
&DSNPRE.GENPANEL	FB	80	6160	Generated ISPF prototype panels
&DSNPRE.GENSRC	FB	80	3120	Generated S-COBOL programs
&DSNPRE.GEN5PANL	VB	136	3132	Generated ISPF prototype panels (MOD5)
&DSNPRE.ISPSLIB	FB	80	3120	User Customized Procedure (skeletons)
&DSNPRE.LOADCICS	U	0	6144	CICS Load Library
&DSNPRE.LOADDLG	U	0	6144	ISPF Dialog Load Library
&DSNPRE.LOADIMS	U	0	6144	IMS Load Library
&DSNPRE.LOADISPF	U	0	6144	ISPF prototype Load Library
&DSNPRE.LOADMVS	U	0	6144	BATCH Load Library
&DSNPRE.OBJCICS	FB	80	3200	CICS Object Modules
&DSNPRE.OBJDLG	FB	80	3200	ISFP Dialog Object Modules
&DSNPRE.OBJIMS	FB	80	3200	IMS Object Modules
&DSNPRE.OBJISPF	FB	80	3200	ISPF prototype Object Modules
&DSNPRE.OBJMVS	FB	80	3200	BATCH Object Modules
&DSNPRE.PSBLIB	U	0	6144	PSB Load Library
&DSNPRE.PSBSRC	FB	80	3120	PSB Source Library
&DSNPRE.SCRCOPY	FB	81	6156	Screen Documentation
&DSNPRE.SCRSYMB	FB	80	6160	Generated Screen Macro Symbols
&DSNPRE.TFORMAT	U	0	6144	IMS Format Library
&DSNPRE.USERMACS	FB	80	6160	User Written Macros
&SYSUID.USER.CLIST	FB	80	3120	User CLISTs (optional)
&SYSUID.ISPF.ISPPROF	FB	80	3120	User Profile (default name)

DDIFILE Data Set

Data Set Name	RECFM	LRECL	BLKSZ	Description
&DDIPRE.DDIFILE	KSDSD	RECSZ	238	DDI VSAM FILE

PDS Names and Descriptions

Data Set Name	RECFM	LRECL	BLKSZ	Description
&APSPRE.APSMACS	FB	80	6160	APS Supplied DB/DC Macros
&APSPRE.CLIST	FB	80	3120	APS CLISTs
&APSPRE.CNTL	FB	80	3120	APS Control Records
&APSPRE.COPYLIB	FB	80	3120	APS/SQL Repository Copybooks
&APSPRE.DBRMLIB2	FB	80	6160	DB2 Request Modules
&APSPRE.ISPLLIB2	U	0	6144	APS ISPF Programs compiled with COBOL for MVS
&APSPRE.ISPMLIB	FB	80	3120	APS ISPF Message Library
&APSPRE.ISPPLIB	FB	80	3120	APS ISPF Panels (no HELP panels)
&APSPRE.ISPPLIBH	FB	80	3120	APS ISPF Panels (HELP panels only)
&APSPRE.ISPPLIBX	FB	80	3120	APS pre-processed Panels (user selected)
&APSPRE.ISPSLIB	FB	80	3120	APS ISPF File Tailoring skeletons (JCL)
&APSPRE.ISPTLIB	FB	80	3120	APS ISPF Command Tables
&APSPRE.LINKLST	U	0	6144	Selected APS modules which would need to be copied to LINKLST if ISPLLIB2/LOADLIB2 were in the (E)PLA and all APS ISPPLIB/STEPLIBs were removed
&APSPRE.LOADLIB2	U	0	6144	APS Batch Programs compiled with COBOL for MVS
&APSPRE.OBJECT2	FB	80	3200	APS/SQL Object Modules compiled with COBOL for MVS (may be archived/deleted after install)
&&AUTHMOD	U	0	6144	SITE/CPU Authorization Module copied into LOADLIB, ISPLLIB and LINKLST and deleted
&&AUTHKEY	FB	80	3120	SITE/CPU Authorization Module Source copied into CNTL and deleted
&&OBJECT2	FB	80	3200	APSCOMP Pre-Compiler Object compiled with COBOL for MVS linked into LOADLIB2 and deleted

APS/SQL Common Data Area Tables

COLM06 Table

Column Name	Type	Nulls
HIGH_LEVEL_QUAL_ID	SMALLINT	NOT NULL
COLM_NAME	CHAR(18)	NOT NULL
TABL_NAME	CHAR(18)	NOT NULL
TABL_CREATOR	CHAR(8)	NOT NULL
INTERNAL_ID	FLOAT	NOT NULL
ALIAS_INDICATOR	CHAR(1)	NOT NULL
ALIAS_INT_ID	FLOAT	NOT NULL
LOCKED_STATU	SCHAR(1)	NOT NULL
CREATED_DATE	CHAR(6)	NOT NULL
CREATED_TIME	CHAR(6)	NOT NULL
CREATED_BY_ID	CHAR(8)	NOT NULL
LST_CHG_DATE	CHAR(6)	NOT NULL
LST_CHG_TIME	CHAR(6)	NOT NULL
LST_CHG_BY_ID	CHAR(8)	NOT NULL
OWNER	CHAR(8)	NOT NULL
QUALITY_INDICATOR	CHAR(2)	NOT NULL
LIFE_CYCLE_PHASE	CHAR(2)	NOT NULL
BRIEF_DESCRIPTION	CHAR(60)	NOT NULL
SEQNO	SMALLINT	NOT NULL
TABL_OR_VIEW_IND	CHAR(1)	NOT NULL
BASED_ON_TYPE	CHAR(1)	NOT NULL
COLR_HLQID	SMALLINT	NOT NULL
COLR_NAME	CHAR(45)	NOT NULL
COLR_TYPE	CHAR(2)	NOT NULL
COLR_OCCNO	SMALLINT	NOT NULL
DEFAULT_PDAT_EXIST	CHAR(1)	NOT NULL
DEFAULT_PDAT_HLQID	SMALLINT	NOT NULL
DEFAULT_PDAT_NAME	CHAR(31)	NOT NULL
DEFAULT_PDAT_OCCNO	SMALLINT	NOT NULL

COLR06 Table

Column Name	Type	Nulls
HIGH_LEVEL_QUAL_ID	SMALLINT	NOT NULL
COLR_NAME	CHAR(45)	NOT NULL
COLR_TYPE	CHAR(2)	NOT NULL
COLR_OCCNO	SMALLINT	NOT NULL
INTERNAL_ID	FLOAT	NOT NULL
ALIAS_INDICATOR	CHAR(1)	NOT NULL
ALIAS_INT_ID	FLOAT	NOT NULL
LOCKED_STATUS	CHAR(1)	NOT NULL
CREATED_DATE	CHAR(6)	NOT NULL
CREATED_TIME	CHAR(6)	NOT NULL
CREATED_BY_ID	CHAR(8)	NOT NULL
LST_CHG_DATE	CHAR(6)	NOT NULL
LST_CHG_TIME	CHAR(6)	NOT NULL
LST_CHG_BY_ID	CHAR(8)	NOT NULL
OWNER	CHAR(8)	NOT NULL
QUALITY_INDICATOR	CHAR(2)	NOT NULL
LIFE_CYCLE_PHASE	CHAR(2)	NOT NULL
BRIEF_DESCRIPTION	CHAR(60)	NOT NULL
COLR_NAME_TYPE	CHAR(1)	NOT NULL
COLM_HLQID	SMALLINT	NOT NULL
COLM_NAME	CHAR(18)	NOT NULL
TABL_NAME	CHAR(18)	NOT NULL
TABL_CREATOR	CHAR(8)	NOT NULL
DEF_FOR_COLR_TYPE	CHAR(1)	NOT NULL
COLR_OVERRIDABLE	CHAR(1)	NOT NULL
DEFAULT_PDAT_EXIST	CHAR(1)	NOT NULL
DEFAULT_PDAT_HLQID	SMALLINT	NOT NULL
DEFAULT_PDAT_NAME	CHAR(31)	NOT NULL
DEFAULT_PDAT_OCCNO	SMALLINT	NOT NULL
COLTYPE	CHAR(8)	NOT NULL
COLM_LENGTH	SMALLINT	NOT NULL
DECIMAL_PLACES	SMALLINT	NOT NULL
COLNUL	CHAR(1)	NOT NULL
DEFAULT	CHAR(1)	NOT NULL
FLDPROC	CHAR(8)	NOT NULL
LABELON	CHAR(30)	NOT NULL
BITDATA	CHAR(1)	NOT NULL W/DEFAULT

DBSE06 Table

Column Name	Type	Nulls
HIGH_LEVEL_QUAL_ID	SMALLINT	NOT NULL
DBSE_NAME	CHAR(8)	NOT NULL
INTERNAL_ID	FLOAT	NOT NULL
ALIAS_INDICATOR	CHAR(1)	NOT NULL
ALIAS_INT_ID	FLOAT	NOT NULL
LOCKED_STATUS	CHAR(1)	NOT NULL
CREATED_DATE	CHAR(6)	NOT NULL
CREATED_TIME	CHAR(6)	NOT NULL
CREATED_BY_ID	CHAR(8)	NOT NULL
LST_CHG_DATE	CHAR(6)	NOT NULL
LST_CHG_TIME	CHAR(6)	NOT NULL
LST_CHG_BY_ID	CHAR(8)	NOT NULL
OWNER	CHAR(8)	NOT NULL
QUALITY_INDICATOR	CHAR(2)	NOT NULL
LIFE_CYCLE_PHASE	CHAR(2)	NOT NULL
BRIEF_DESCRIPTION	CHAR(60)	NOT NULL
DBSE_CREATOR	CHAR(8)	NOT NULL
STGP_NAME	CHAR(8)	NOT NULL
BPOOL	CHAR(8)	NOT NULL

INDX06 Table Description

Column Name	Type	Nulls
HIGH_LEVEL_QUAL_ID	SMALLINT	NOT NULL
INDX_NAME	CHAR(18)	NOT NULL
INDX_CREATOR	CHAR(8)	NOT NULL
INTERNAL_ID	FLOAT	NOT NULL
ALIAS_INDICATOR	CHAR(1)	NOT NULL
ALIAS_INT_ID	FLOAT	NOT NULL
LOCKED_STATUS	CHAR(1)	NOT NULL
CREATED_DATE	CHAR(6)	NOT NULL
CREATED_TIME	CHAR(6)	NOT NULL
CREATED_BY_ID	CHAR(8)	NOT NULL
LST_CHG_DATE	CHAR(6)	NOT NULL
LST_CHG_TIME	CHAR(6)	NOT NULL
LST_CHG_BY_ID	CHAR(8)	NOT NULL
OWNER	CHAR(8)	NOT NULL
QUALITY_INDICATOR	CHAR(2)	NOT NULL
LIFE_CYCLE_PHASE	CHAR(2)	NOT NULL
BRIEF_DESCRIPTION	CHAR(60)	NOT NULL
TABL_NAME	CHAR(18)	NOT NULL
TABL_CREATOR	CHAR(8)	NOT NULL
UNIQUERULE	CHAR(1)	NOT NULL
CLUSTERING	CHAR(1)	NOT NULL
BPOOL	CHAR(8)	NOT NULL
PGSIZE	SMALLINT	NOT NULL
ERASERULE	CHAR(1)	NOT NULL
DSETPASS	CHAR(8)	NOT NULL
CLOSERULE	CHAR(1)	NOT NULL

INDXCOLM06 Table Description

Column Name	Type	Nulls
HIGH_LEVEL_QUAL_ID	SMALLINT	NOT NULL
INDX_NAME	CHAR(18)	NOT NULL
INDX_CREATOR	CHAR(8)	NOT NULL
COLM_NAME	CHAR(18)	NOT NULL
TABL_NAME	CHAR(18)	NOT NULL
TABL_CREATOR	CHAR(8)	NOT NULL
INTERNAL_ID	FLOAT	NOT NULL
ALIAS_INDICATOR	CHAR(1)	NOT NULL
ALIAS_INT_ID	FLOAT	NOT NULL
LOCKED_STATUS	CHAR(1)	NOT NULL
CREATED_DATE	CHAR(6)	NOT NULL
CREATED_TIME	CHAR(6)	NOT NULL
CREATED_BY_ID	CHAR(8)	NOT NULL
LST_CHG_DATE	CHAR(6)	NOT NULL
LST_CHG_TIME	CHAR(6)	NOT NULL
LST_CHG_BY_ID	CHAR(8)	NOT NULL
OWNER	CHAR(8)	NOT NULL
QUALITY_INDICATOR	CHAR(2)	NOT NULL
LIFE_CYCLE_PHASE	CHAR(2)	NOT NULL
BRIEF_DESCRIPTION	CHAR(60)	NOT NULL
SEQNO	SMALLINT	NOT NULL
ORDERING	CHAR(1)	NOT NULL

IXPT06 Table

Column Name	Type	Nulls
HIGH_LEVEL_QUAL_ID	SMALLINT	NOT NULL
INDX_PARTITION	SMALLINT	NOT NULL
INDX_NAME	CHAR(18)	NOT NULL
INDX_CREATOR	CHAR(8)	NOT NULL
INTERNAL_ID	FLOAT	NOT NULL
ALIAS_INDICATOR	CHAR(1)	NOT NULL
ALIAS_INT_ID	FLOAT	NOT NULL
LOCKED_STATUS	CHAR(1)	NOT NULL
CREATED_DATE	CHAR(6)	NOT NULL
CREATED_TIME	CHAR(6)	NOT NULL
CREATED_BY_ID	CHAR(8)	NOT NULL
LST_CHG_DATE	CHAR(6)	NOT NULL
LST_CHG_TIME	CHAR(6)	NOT NULL
LST_CHG_BY_ID	CHAR(8)	NOT NULL
OWNER	CHAR(8)	NOT NULL
QUALITY_INDICATOR	CHAR(2)	NOT NULL
LIFE_CYCLE_PHASE	CHAR(2)	NOT NULL
BRIEF_DESCRIPTION	CHAR(60)	NOT NULL
PQTY	INTEGER	NOT NULL
SQTY	SMALLINT	NOT NULL
STORETYPE	CHAR(1)	NOT NULL
STGP_NAME	CHAR(8)	NOT NULL
VCATNAME	CHAR(8)	NOT NULL
FREEPAGE	SMALLINT	NOT NULL
PCTFREE	SMALLINT	NOT NULL
LIMITKEY	VARCHAR(512)	NOT NULL

LDAT06 Table

Column Name	Type	Nulls
HIGH_LEVEL_QUAL_ID	SMALLINT	NOT NULL
LDAT_NAME	CHAR(45)	NOT NULL
INTERNAL_ID	FLOAT	NOT NULL
ALIAS_INDICATOR	CHAR(1)	NOT NULL
ALIAS_INT_ID	FLOAT	NOT NULL
LOCKED_STATUS	CHAR(1)	NOT NULL
CREATED_DATE	CHAR(6)	NOT NULL
CREATED_TIME	CHAR(6)	NOT NULL
CREATED_BY_ID	CHAR(8)	NOT NULL
LST_CHG_DATE	CHAR(6)	NOT NULL
LST_CHG_TIME	CHAR(6)	NOT NULL
LST_CHG_BY_ID	CHAR(8)	NOT NULL
OWNER	CHAR(8)	NOT NULL
QUALITY_INDICATOR	CHAR(2)	NOT NULL
LIFE_CYCLE_PHASE	CHAR(2)	NOT NULL
BRIEF_DESCRIPTION	CHAR(60)	NOT NULL
ELEMENT_STRUCT_IND	CHAR(1)	NOT NULL
USRVW_DATA_ENT_IND	CHAR(1)	NOT NULL
USER_VIEW_SUBTYPE	CHAR(2)	NOT NULL

LDATTABL06 Table

Column Name	Type	Nulls
HIGH_LEVEL_QUAL_ID	SMALLINT	NOT NULL
LDAT_NAME	CHAR(45)	NOT NULL
TABL_HLQID	SMALLINT	NOT NULL
TABL_NAME	CHAR(18)	NOT NULL
TABL_CREATOR	CHAR(8)	NOT NULL
INTERNAL_ID	FLOAT	NOT NULL
ALIAS_INDICATOR	CHAR(1)	NOT NULL
ALIAS_INT_ID	FLOAT	NOT NULL
LOCKED_STATUS	CHAR(1)	NOT NULL
CREATED_DATE	CHAR(6)	NOT NULL
CREATED_TIME	CHAR(6)	NOT NULL
CREATED_BY_ID	CHAR(8)	NOT NULL
LST_CHG_DATE	CHAR(6)	NOT NULL
LST_CHG_TIME	CHAR(6)	NOT NULL
LST_CHG_BY_ID	CHAR(8)	NOT NULL
OWNER	CHAR(8)	NOT NULL
QUALITY_INDICATOR	CHAR(2)	NOT NULL
LIFE_CYCLE_PHASE	CHAR(2)	NOT NULL
BRIEF_DESCRIPTION	CHAR(60)	NOT NULL
DEFAULT_LDAT_IND	CHAR(1)	NOT NULL
USE_UNDER_CONDX	CHAR(40)	NOT NULL

LDATCOLM06 Table

Column Name	Type	Nulls
HIGH_LEVEL_QUAL_ID	SMALLINT	NOT NULL
LDAT_NAME	CHAR(45)	NOT NULL
COLM_HLQID	SMALLINT	NOT NULL
COLM_NAME	CHAR(18)	NOT NULL
TABL_NAME	CHAR(18)	NOT NULL
TABL_CREATOR	CHAR(8)	NOT NULL
INTERNAL_ID	FLOAT	NOT NULL
ALIAS_INDICATOR	CHAR(1)	NOT NULL
ALIAS_INT_ID	FLOAT	NOT NULL
LOCKED_STATUS	CHAR(1)	NOT NULL
CREATED_DATE	CHAR(6)	NOT NULL
CREATED_TIME	CHAR(6)	NOT NULL
CREATED_BY_ID	CHAR(8)	NOT NULL
LST_CHG_DATE	CHAR(6)	NOT NULL
LST_CHG_TIME	CHAR(6)	NOT NULL
LST_CHG_BY_ID	CHAR(8)	NOT NULL
OWNER	CHAR(8)	NOT NULL
QUALITY_INDICATOR	CHAR(2)	NOT NULL
LIFE_CYCLE_PHASE	CHAR(2)	NOT NULL
BRIEF_DESCRIPTION	CHAR(60)	NOT NULL
DEFAULT_LDAT_IND	CHAR(1)	NOT NULL
USE_UNDER_CONDX	CHAR(40)	NOT NULL

LDEL06 Table

Column Name	Type	Nulls
HIGH_LEVEL_QUAL_ID	SMALLINT	NOT NULL
LDEL_NAME	CHAR(45)	NOT NULL
CANONICAL_LENGTH	CHAR(5)	NOT NULL
CANONICAL_FORMAT	CHAR(6)	NOT NULL
PROMPT	CHAR(80)	NOT NULL
HEADER_NEWLN_DELIM	CHAR(1)	NOT NULL
SHORT_HEADER	CHAR(32)	NOT NULL
HEADER	CHAR(64)	NOT NULL
LONG_HEADER	CHAR(132)	NOT NULL

PDB2TXAD06 Table

Column Name	Type	Nulls
HIGH_LEVEL_QUAL_ID	SMALLINT	NOT NULL
TABLE_ID	SMALLINT	NOT NULL
INTERNAL_ID	FLOAT	NOT NULL
TEXT_TYPE	CHAR(2)	NOT NULL
CREATED_DATE	CHAR(6)	NOT NULL
CREATED_TIME	CHAR(6)	NOT NULL
LST_CHG_DATE	CHAR(6)	NOT NULL
LST_CHG_TIME	CHAR(6)	NOT NULL
LST_CHG_BY_ID	CHAR(8)	NOT NULL
WHERE_STORED_IND	CHAR(1)	NOT NULL
TEXT_TABLE	CHAR(2)	NOT NULL
TEXT_LRECL	SMALLINT	NOT NULL
TEXT_DSN	CHAR(44)	NOT NULL
TEXT_MEMBER	CHAR(8)	NOT NULL

PDB2TX0006 Table

Column Name	Type	Nulls
HIGH_LEVEL_QUAL_ID	SMALLINT	NOT NULL
TABLE_ID	SMALLINT	NOT NULL
INTERNAL_ID	FLOAT	NOT NULL
TEXT_TYPE	CHAR(2)	NOT NULL
SEQNO	SMALLINT	NOT NULL
TEXT_LINE	VARCHAR(254)	NOT NULL

PDB2CHGM06 Table

Column Name	Type	Nulls
HIGH_LEVEL_QUAL_ID	SMALLINT	NOT NULL
TABLE_ID	SMALLINT	NOT NULL
INTERNAL_ID	FLOAT	NOT NULL
ACTION_TYPE	CHAR(2)	NOT NULL
ACTION_TYPE_DETAIL	CHAR(2)	NOT NULL
ACTION_DATE	CHAR(6)	NOT NULL
ACTION_TIME	CHAR(6)	NOT NULL
TEXT_TYPE	CHAR(2)	NOT NULL
ACTION_BY_ID	CHAR(8)	NOT NULL
ACTION_BY_PROCESS	CHAR(8)	NOT NULL
SOURCE_ENTITY_TYPE	CHAR(4)	NOT NULL
SOURCE_ENTITY_PDS	CHAR(44)	NOT NULL
SOURCE_ENTITY_NAME	CHAR(8)	NOT NULL
SOURCE_ENTITY_VMOD	CHAR(4)	NOT NULL
WHERE_STORED_IND	CHAR(1)	NOT NULL
TEXT_TABLE	CHAR(2)	NOT NULL
TEXT_LRECL	SMALLINT	NOT NULL
TEXT_DSN	CHAR(44)	NOT NULL
TEXT_MEMBER	CHAR(8)	NOT NULL
REASON_FOR_ACTION	CHAR(20)	NOT NULL
ACTION_MGMT_ID	CHAR(20)	NOT NULL

PDB2CM0006 Table

Column Name	Type	Nulls
HIGH_LEVEL_QUAL_ID	SMALLINT	NOT NULL
TABLE_ID	SMALLINT	NOT NULL
INTERNAL_ID	FLOAT	NOT NULL
ACTION_TYPE	CHAR(2)	NOT NULL
ACTION_TYPE_DETAIL	CHAR(2)	NOT NULL
ACTION_DATE	CHAR(6)	NOT NULL
ACTION_TIME	CHAR(6)	NOT NULL
TEXT_TYPE	CHAR(2)	NOT NULL
SEQNO	SMALLINT	NOT NULL
TEXT_LINE	VARCHAR(254)	NOT NULL

STGP06 Table

Column Name	Type	Nulls
HIGH_LEVEL_QUAL_ID	SMALLINT	NOT NULL
STGP_NAME	CHAR(8)	NOT NULL
INTERNAL_ID	FLOAT	NOT NULL
ALIAS_INDICATOR	CHAR(1)	NOT NULL
ALIAS_INT_ID	FLOAT	NOT NULL
LOCKED_STATUS	CHAR(1)	NOT NULL
CREATED_DATE	CHAR(6)	NOT NULL
CREATED_TIME	CHAR(6)	NOT NULL
CREATED_BY_ID	CHAR(8)	NOT NULL
LST_CHG_TIME	CHAR(6)	NOT NULL
LST_CHG_BY_ID	CHAR(8)	NOT NULL
OWNER	CHAR(8)	NOT NULL
QUALITY_INDICATOR	CHAR(2)	NOT NULL
LIFE_CYCLE_PHASE	CHAR(2)	NOT NULL
BRIEF_DESCRIPTION	CHAR(60)	NOT NULL
VCATNAME	CHAR(8)	NOT NULL
VPASSWORD	CHAR(8)	NOT NULL

STGV06 Table

Column Name	Type	Nulls
HIGH_LEVEL_QUAL_ID	SMALLINT	NOT NULL
STGP_NAME	CHAR(8)	NOT NULL
VOLUME_ID	CHAR(6)	NOT NULL
INTERNAL_ID	FLOAT	NOT NULL
ALIAS_INDICATOR	CHAR(1)	NOT NULL
ALIAS_INT_ID	FLOAT	NOT NULL
LOCKED_STATUS	CHAR(1)	NOT NULL
CREATED_DATE	CHAR(6)	NOT NULL
CREATED_TIME	CHAR(6)	NOT NULL
CREATED_BY_ID	CHAR(8)	NOT NULL
LST_CHG_DATE	CHAR(6)	NOT NULL
LST_CHG_TIME	CHAR(6)	NOT NULL
LST_CHG_BY_ID	CHAR(8)	NOT NULL
OWNER	CHAR(8)	NOT NULL
QUALITY_INDICATOR	CHAR(2)	NOT NULL
LIFE_CYCLE_PHASE	CHAR(2)	NOT NULL
BRIEF_DESCRIPTION	CHAR(60)	NOT NULL

TBSP06 Table

Column Name	Type	Nulls
HIGH_LEVEL_QUAL_ID	SMALLINT	NOT NULL
TBSP_NAME	CHAR(8)	NOT NULL
DBSE_NAME	CHAR(8)	NOT NULL
INTERNAL_ID	FLOAT	NOT NULL
ALIAS_INDICATOR	CHAR(1)	NOT NULL
ALIAS_INT_ID	FLOAT	NOT NULL
LOCKED_STATUS	CHAR(1)	NOT NULL
CREATED_DATE	CHAR(6)	NOT NULL
CREATED_TIME	CHAR(6)	NOT NULL
CREATED_BY_ID	CHAR(8)	NOT NULL
LST_CHG_DATE	CHAR(6)	NOT NULL
LST_CHG_TIME	CHAR(6)	NOT NULL
LST_CHG_BY_ID	CHAR(8)	NOT NULL
OWNER	CHAR(8)	NOT NULL
LST_CHG_BY_ID	CHAR(8)	NOT NULL
QUALITY_INDICATOR	CHAR(2)	NOT NULL
LIFE_CYCLE_PHASE	CHAR(2)	NOT NULL
QUALITY_INDICATOR	CHAR(2)	NOT NULL
BRIEF_DESCRIPTION	CHAR(60)	NOT NULL
TBSP_CREATOR	CHAR(8)	NOT NULL
BPOOL	CHAR(8)	NOT NULL
PARTITIONS	SMALLINT	NOT NULL
LOCKRULE	CHAR(1)	NOT NULL
ERASERULE	CHAR(1)	NOT NULL
DSETPASS	CHAR(8)	NOT NULL
CLOSERULE	CHAR(1)	NOT NULL
SEGSIZE	SMALLINIT	NOT NULL W/DEFAULT

TSPT06 Table

Column Name	Type	Nulls
HIGH_LEVEL_QUAL_ID	SMALLINT	NOT NULL
TBSP_PARTITION	SMALLINT	NOT NULL
TBSP_NAME	CHAR(8)	NOT NULL
DBSE_NAME	CHAR(8)	NOT NULL
INTERNAL_ID	FLOAT	NOT NULL
ALIAS_INDICATOR	CHAR(1)	NOT NULL
ALIAS_INT_ID	FLOAT	NOT NULL
LOCKED_STATUS	CHAR(1)	NOT NULL
CREATED_DATE	CHAR(6)	NOT NULL
CREATED_TIME	CHAR(6)	NOT NULL
CREATED_BY_ID	CHAR(8)	NOT NULL
LST_CHG_DATE	CHAR(6)	NOT NULL
LST_CHG_TIME	CHAR(6)	NOT NULL
LST_CHG_BY_ID	CHAR(8)	NOT NULL
OWNER	CHAR(8)	NOT NULL
QUALITY_INDICATOR	CHAR(2)	NOT NULL
LIFE_CYCLE_PHASE	CHAR(2)	NOT NULL
BRIEF_DESCRIPTION	CHAR(60)	NOT NULL
INDX_NAME	CHAR(18)	NOT NULL
INDX_CREATOR	CHAR(8)	NOT NULL
PQTY	INTEGER	NOT NULL
SQTY	SMALLINT	NOT NULL
STORETYPE	CHAR(1)	NOT NULL
STGP_NAME	CHAR(8)	NOT NULL
VCATNAME	CHAR(8)	NOT NULL
FREEPAGE	SMALLINT	NOT NULL
PCTFREE	SMALLINT	NOT NULL

TABL06 Table

Column Name	Type	Nulls
HIGH_LEVEL_QUAL_ID	SMALLINT	NOT NULL
TABL_NAME	CHAR(18)	NOT NULL
TABL_CREATOR	CHAR(8)	NOT NULL
INTERNAL_ID	FLOAT	NOT NULL
ALIAS_INDICATOR	CHAR(1)	NOT NULL
ALIAS_INT_ID	FLOAT	NOT NULL
LOCKED_STATUS	CHAR(1)	NOT NULL
CREATED_DATE	CHAR(6)	NOT NULL
CREATED_TIME	CHAR(6)	NOT NULL
CREATED_BY_ID	CHAR(8)	NOT NULL
LST_CHG_DATE	CHAR(6)	NOT NULL
LST_CHG_TIME	CHAR(6)	NOT NULL
LST_CHG_BY_ID	CHAR(8)	NOT NULL
OWNER	CHAR(8)	NOT NULL
QUALITY_INDICATOR	CHAR(2)	NOT NULL
LIFE_CYCLE_PHASE	CHAR(2)	NOT NULL
BRIEF_DESCRIPTION	CHAR(60)	NOT NULL
TABL_OR_VIEW_IND	CHAR(1)	NOT NULL
DBSE_NAME	CHAR(8)	NOT NULL
TBSP_NAME	CHAR(8)	NOT NULL
EDTPROC	CHAR(8)	NOT NULL
VALPROC	CHAR(8)	NOT NULL
LABELON	CHAR(30)	NOT NULL
CHECK	CHAR(1)	NOT NULL
INIT_NUM_ROWS	INTEGER	NOT NULL
FINAL_NUM_ROWS	INTEGER	NOT NULL
AUDITING	CHAR(1)	NOT NULL
LOCATION	CHAR(16)	NOT NULL
TBCREATOR	CHAR(8)	NOT NULL
TBNAME	CHAR(18)	NOT NULL

TABL06 Table/View Relationship Description

Column Name	Type	Nulls
HIGH_LEVEL_QUAL_ID	SMALLINT	NOT NULL
VIEW_NAME	CHAR(18)	NOT NULL
VIEW_CREATOR	CHAR(8)	NOT NULL
TABL_HLQID	SMALLINT	NOT NULL
TABL_NAME	CHAR(18)	NOT NULL
TABL_CREATOR	CHAR(8)	NOT NULL
INTERNAL_ID	FLOAT	NOT NULL
ALIAS_INDICATOR	CHAR(1)	NOT NULL
ALIAS_INT_ID	FLOAT	NOT NULL
LOCKED_STATUS	CHAR(1)	NOT NULL
CREATED_DATE	CHAR(6)	NOT NULL
CREATED_TIME	CHAR(6)	NOT NULL
CREATED_BY_ID	CHAR(8)	NOT NULL
LST_CHG_DATE	CHAR(6)	NOT NULL
LST_CHG_TIME	CHAR(6)	NOT NULL
LST_CHG_BY_ID	CHAR(8)	NOT NULL
OWNER	CHAR(8)	NOT NULL
QUALITY_INDICATOR	CHAR(2)	NOT NULL
LIFE_CYCLE_PHASE	CHAR(2)	NOT NULL
BRIEF_DESCRIPTION	CHAR(60)	NOT NULL
CORRELATION_NAME	CHAR(18)	NOT NULL

SCHM06 Subschema Table

Column Name	Type	Nulls
HIGH_LEVEL_QUAL_ID	SMALLINT
SCHM_NAME	CHAR(8)
INTERNAL_ID	FLOAT
ALIAS_INDICATOR	CHAR(1)
ALIAS_INT_ID	FLOAT
LOCKED_STATUS	CHAR(1)
CREATED_DATE	CHAR(6)
CREATED_TIME	CHAR(6)
CREATED_BY_ID	CHAR(8)
LST_CHG_DATE	CHAR(6)
LST_CHG_TIME	CHAR(6)
LST_CHG_BY_ID	CHAR(8)
OWNER	CHAR(8)
QUALITY_INDICATOR	CHAR(2)
LIFE_CYCLE_PHASE	CHAR(2)
BRIEF_DESCRIPTION	CHAR(60)
TABL_CREATOR_OV	CHAR(8)

SCHMTABL06 Subschema Table/View Relationship

Column Name	Type	Nulls
HIGH_LEVEL_QUAL_ID	SMALLINT	NOT NULL
SCHM_NAME	CHAR(8)	NOT NULL
TABL_NAME	CHAR(18)	NOT NULL
TABL_CREATOR	CHAR(8)	NOT NULL
INTERNAL_ID	FLOAT	NOT NULL
ALIAS_INDICATOR	CHAR(1)	NOT NULL
ALIAS_INT_ID	FLOAT	NOT NULL
LOCKED_STATUS	CHAR(1)	NOT NULL
CREATED_DATE	CHAR(6)	NOT NULL
CREATED_TIME	CHAR(6)	NOT NULL
CREATED_BY_ID	CHAR(8)	NOT NULL
LST_CHG_DATE	CHAR(6)	NOT NULL
LST_CHG_TIME	CHAR(6)	NOT NULL
LST_CHG_BY_ID	CHAR(8)	NOT NULL
OWNER	CHAR(8)	NOT NULL
QUALITY_INDICATOR	CHAR(2)	NOT NULL
LIFE_CYCLE_PHASE	CHAR(2)	NOT NULL
BRIEF_DESCRIPTION	CHAR(60)	NOT NULL
SEQNO	SMALLINT	NOT NULL
COPY_NAME	CHAR(8)	NOT NULL