Skip to Main Content
Return to Navigation

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:

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, Microsoft, Sybase, Informix

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, Microsoft, Sybase, Informix

Description

LASTRUN

NCHAR(60)

PSCIAPCXREFTIME for DB2/OS390, DB2/UNIX

Description

LASTRUN

CHAR(120)