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 |