Skip to Main Content
Return to Navigation

File Pre-Processor

The File Pre-processor generates the following database tables that Change Impact Analysis reads to perform analysis.

Note: You must have permission to create, delete from and write to these files. If you have full privileges, you run the pre-processor and create these files beforehand.

PSFILEPROCESSRUN for Oracle

Description

LASTREFRESHDTTM

DATE

FPPSTATUS

VARCHAR2(10) NOT NULL

PSFILEPROCESSRUN for MicroSoft and Sybase

Description

LASTREFRESHDTTM

PSDATETIME

FPPSTATUS

CHAR(10) NOT NULL

PSFILEPROCESSRUN for Informix

Description

LASTREFRESHDTTM

DATETIME YEAR TO FRACTION(3)

FPPSTATUS

CHAR(10) NOT NULL

PSFILEPROCESSRUN for DB2/Unix, DB2/OS390

Description

LASTREFRESHDTTM

TIMESTAMP

FPPSTATUS

CHAR(10) NOT NULL

PSSQLXREFDEFN for Oracle

Description

XREF_ID

VARCHAR2(128) NOT NULL

XREF_SQLTYPE

VARCHAR2(1) NOT NULL

DBTYPE

VARCHAR2(1) NOT NULL

XREF_GROUPBY_CNT

SMALLINT NOT NULL

XREF_ORDERBY_CNT

SMALLINT NOT NULL

XREF_HAVING_CNT

SMALLINT NOT NULL

XREF_SUBQUERY_CNT

SMALLINT NOT NULL

XREF_OUTERJOIN_CNT

SMALLINT NOT NULL

LASTUPDDTTM

DATE

SQLTEXT

LONG VARCHAR

PSSQLXREFDEFN for MicroSoft, Sybase

Description

XREF_ID

CHAR(128) NOT NULL

XREF_SQLTYPE

CHAR(1) NOT NULL

DBTYPE

CHAR(1) NOT NULL

XREF_GROUPBY_CNT

SMALLINT NOT NULL

XREF_ORDERBY_CNT

SMALLINT NOT NULL

XREF_HAVING_CNT

SMALLINT NOT NULL

XREF_SUBQUERY_CNT

SMALLINT NOT NULL

XREF_OUTERJOIN_CNT

SMALLINT NOT NULL

LASTUPDDTTM

PSDATETIME NULL

SQLTEXT

TEXT NULL

PSSQLXREFDEFN for Informix

Description

XREF_ID

CHAR(128) NOT NULL

XREF_SQLTYPE

CHAR(1) NOT NULL

DBTYPE

CHAR(1) NOT NULL

XREF_GROUPBY_CNT

SMALLINT NOT NULL

XREF_ORDERBY_CNT

SMALLINT NOT NULL

XREF_HAVING_CNT

SMALLINT NOT NULL

XREF_SUBQUERY_CNT

SMALLINT NOT NULL

XREF_OUTERJOIN_CNT

SMALLINT NOT NULL

LASTUPDDTTM

DATETIME YEAR TO FRACTION(3)

SQLTEXT

TEXT

PSSQLXREFDEFN for DB2/Unix, DB2/OS390

Description

XREF_ID

CHAR(128) NOT NULL

XREF_SQLTYPE

CHAR(1) NOT NULL

DBTYPE

CHAR(1) NOT NULL

XREF_GROUPBY_CNT

SMALLINT NOT NULL

XREF_ORDERBY_CNT

SMALLINT NOT NULL

XREF_HAVING_CNT

SMALLINT NOT NULL

XREF_SUBQUERY_CNT

SMALLINT NOT NULL

XREF_OUTERJOIN_CNT

SMALLINT NOT NULL

LASTUPDDTTM

TIMESTAMP

SQLTEXT

LONG VARCHAR

PSSQLXREFITEM for Oracle

Description

XREF_ID

VARCHAR2(128) NOT NULL

XREF_SQLTYPE

VARCHAR2(1) NOT NULL

DBTYPE

VARCHAR2(1) NOT NULL

XREF_ITEMSEQ

SMALLINT NOT NULL

XREF_ITEMTYPE

VARCHAR2(4) NOT NULL

XREF_RECNAME

VARCHAR2(30) NOT NULL

XREF_VALUE

VARCHAR2(128) NOT NULL

XREF_USAGE

VARCHAR2(4) NOT NULL

XREF_CLAUSE

VARCHAR2(5) NOT NULL

PSSQLXREFITEM for MicroSoft, Sybase, Informix, DB2/Unix, DB2/OS390

Description

XREF_ID

CHAR(128) NOT NULL

XREF_SQLTYPE

CHAR(1) NOT NULL

DBTYPE

CHAR(1) NOT NULL

XREF_ITEMSEQ

SMALLINT NOT NULL

XREF_ITEMTYPE

CHAR(4) NOT NULL

XREF_RECNAME

CHAR(30) NOT NULL

XREF_VALUE

CHAR(128) NOT NULL

XREF_USAGE

CHAR(4) NOT NULL

XREF_CLAUSE

CHAR(5) NOT NULL

PSFILESQLXREFDEFN Oracle

Description

SOURCE_FILE

VARCHAR2(40) NOT NULL

FILE_TYPE

VARCHAR2(4) NOT NULL

XREF_ID

VARCHAR2(128) NOT NULL

PSFILESQLXREFDEFN for MicroSoft, Sybase, Informix, DB2/Unix, DB2/OS390

Description

SOURCE_FILE

CHAR(40) NOT NULL

FILE_TYPE

CHAR(4) NOT NULL

XREF_ID

CHAR(128) NOT NULL

PSFILEXREFDEFN for Oracle

Description

SOURCE_FILE

VARCHAR2(40) NOT NULL

CALLED_FILE

VARCHAR2(40) NOT NULL

FILE_TYPE

VARCHAR2(3) NOT NULL

PSFILEXREFDEFN for MicroSoft, Sybase, Informix, DB2/Unix, DB2/OS390

Description

SOURCE_FILE

CHAR(40) NOT NULL

CALLED_FILE

CHAR(40) NOT NULL

FILE_TYPE

CHAR(3) NOT NULL