PeopleCode Pre-Processor

You must run the PeopleCode pre-processor to generate the database tables that Change Impact Analysis reads and analyzes. The PeopleCode pre-processor generates two tables:

PSCIAPCXREF
PSCIAPCXREFTIME

You must have permission to create, delete from and write to these files. If you have full privileges, you can create these files prior to using Change Impact Analyzer.

Note: Database administrators may consider assigning user IDs and passwords that grant read-only access to the database. However, users need create and write access to these work tables used by Change Impact Analyzer.

The following tables describe the columns for each of these tables for the different supported databases:

PSCIAPCXREF for Oracle and Microsoft	Description
PROGSEQ	INT NOT NULL
REFOBJECTID1	SMALLINT NOT NULL
REFOBJECTVALUE1	NCHAR(30) NOT NULL
REFOBJECTID2	SMALLINT NOT NULL
REFOBJECTVALUE2	NCHAR(30) NOT NULL
REFOBJECTID3	SMALLINT NOT NULL
REFOBJECTVALUE3	NCHAR(30) NOT NULL
REFOBJECTID4	SMALLINT NOT NULL
REFOBJECTVALUE4	NCHAR(30) NOT NULL
REFOBJECTID5	SMALLINT NOT NULL
REFOBJECTVALUE5	NCHAR(30) NOT NULL
REFOBJECTID6	SMALLINT NOT NULL
REFOBJECTVALUE6	NCHAR(30) NOT NULL
REFOBJECTID7	SMALLINT NOT NULL
REFOBJECTVALUE7	NCHAR(30) NOT NULL
OBJECTID1	SMALLINT NOT NULL
OBJECTVALUE1	NCHAR(30) NOT NULL
OBJECTID2	SMALLINT NOT NULL
OBJECTVALUE2	NCHAR(30) NOT NULL
OBJECTID3	SMALLINT NOT NULL
OBJECTVALUE3	NCHAR(30) NOT NULL
OBJECTID4	SMALLINT NOT NULL
OBJECTVALUE4	NCHAR(30) NOT NULL
OBJECTID5	SMALLINT NOT NULL
OBJECTVALUE5	NCHAR(30) NOT NULL
OBJECTID6	SMALLINT NOT NULL
OBJECTVALUE6	NCHAR(30) NOT NULL
OBJECTID7	SMALLINT NOT NULL
OBJECTVALUE7	NCHAR(30) NOT NULL

PSCIAPCXREF for DB2/OS390, DB2/Unix	Description
PROGSEQ	INT NOT NULL
REFOBJECTID1	SMALLINT NOT NULL
REFOBJECTVALUE1	CHAR(60) NOT NULL
REFOBJECTID2	SMALLINT NOT NULL
REFOBJECTVALUE2	CHAR(60) NOT NULL
REFOBJECTID3	SMALLINT NOT NULL
REFOBJECTVALUE3	CHAR(60) NOT NULL
REFOBJECTID4	SMALLINT NOT NULL
REFOBJECTVALUE4	CHAR(60) NOT NULL
REFOBJECTID5	SMALLINT NOT NULL
REFOBJECTVALUE5	CHAR(60) NOT NULL
REFOBJECTID6	SMALLINT NOT NULL
REFOBJECTVALUE6	CHAR(60) NOT NULL
REFOBJECTID7	SMALLINT NOT NULL
REFOBJECTVALUE7	CHAR(60) NOT NULL
OBJECTID1	SMALLINT NOT NULL
OBJECTVALUE1	CHAR(60) NOT NULL
OBJECTID2	SMALLINT NOT NULL
OBJECTVALUE2	CHAR(60) NOT NULL
OBJECTID3	SMALLINT NOT NULL
OBJECTVALUE3	CHAR(60) NOT NULL
OBJECTID4	SMALLINT NOT NULL
OBJECTVALUE4	CHAR(60) NOT NULL
OBJECTID5	SMALLINT NOT NULL
OBJECTVALUE5	CHAR(60) NOT NULL
OBJECTID6	SMALLINT NOT NULL
OBJECTVALUE6	CHAR(60) NOT NULL
OBJECTID7	SMALLINT NOT NULL
OBJECTVALUE7	CHAR(60) NOT NULL

PSCIAPCXREFTIME for Oracle and Microsoft	Description
LASTRUN	NCHAR(60)

PSCIAPCXREFTIME for DB2/OS390, DB2/UNIX	Description
LASTRUN	CHAR(120)