Document toolbox

Creating the HASH_DICTIONARY Table

Owned by John McKeever

Last updated: Mar 26, 2024

1 min read

This database table needs to be created manually by your Database Administrator using DDL provided below.

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),
    TYPE VARCHAR(9),
    LOCATION VARCHAR(255),
    FILE_NAME VARCHAR(255),
    
    PRIMARY KEY (TABLE_NAME)
);

ODBC

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

Links

© 2015-2024 Data Migrators Pty Ltd.