/

Creating the HASH_DICTIONARY Table

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

Related content

Hashed File Database Tables

Hashed File Database Tables

Server to Parallel Migration

More like this

Hashed File Parameterisation

Hashed File Parameterisation

Server to Parallel Migration

More like this

Job Decomposition

Job Decomposition

Server to Parallel Migration

Read with this

Hashed File Database Tables

Hashed File Database Tables

Scroll Documents Test

More like this

Folder Stage

Server to Parallel Migration

Read with this

(v6 2) Hashed File Database Tables

(v6 2) Hashed File Database Tables

Scroll Documents Test

More like this

© 2015-2024 Data Migrators Pty Ltd.