File Pre-Processor
The File Pre-processor generates the following database tables that Change Impact Analysis reads to perform analysis.
PSFILEPROCESSRUN
PSSQLXREFDEFN
PSSQLXREFITEM
PSFILESQLXREFDEFN
PSFILEXREFDEFN
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 |
Description |
---|---|
LASTREFRESHDTTM |
PSDATETIME |
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 |
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 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, 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, 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, DB2/Unix, DB2/OS390 |
Description |
---|---|
SOURCE_FILE |
CHAR(40) NOT NULL |
CALLED_FILE |
CHAR(40) NOT NULL |
FILE_TYPE |
CHAR(3) NOT NULL |