Breadcrumbs

Creating the HASH_DICTIONARY Table

Create this database table using the vendor-specific DDL provided below. It must be created before running any Hashed File migration Jobs or any Jobs that were generated by S2PX from Server originals that contain Hashed File stages.

Oracle 

CREATE TABLE HASH_DICTIONARY (
    TABLE_NAME VARCHAR2(30),
    TYPE VARCHAR2(9),
    LOCATION VARCHAR2(255),
    FILE_NAME VARCHAR2(255),
    
    PRIMARY KEY (TABLE_NAME)
);

DB2 

CREATE TABLE HASH_DICTIONARY (
    TABLE_NAME VARCHAR(30) NOT NULL,
    TYPE VARCHAR(9),
    LOCATION VARCHAR(255),
    FILE_NAME VARCHAR(255),
    
    PRIMARY KEY (TABLE_NAME)
);

ODBC 

CREATE TABLE HASH_DICTIONARY (
    TABLE_NAME VARCHAR(30) NOT NULL,
    TYPE VARCHAR(9),
    LOCATION VARCHAR(255),
    FILE_NAME VARCHAR(255),
    
    PRIMARY KEY (TABLE_NAME)
);