The madhubload utility loads one or more IBM® Initiate® Master Data Service tables from .unl files.
Option | Type | Description | Default |
---|---|---|---|
-objCode | objCode | Object code (DIC, MEM, AUD, REL, TAG, HST, ANL) for the data to be loaded | NONE |
-tabList | tabList | List of tables to be loaded. Use ALL for all tables, or specify individual tables by name (for example, mpi_memstat). | NONE |
-unlDir | dirName | Location of the .unl files | NONE |
-onepass | Implies –truncate, -loaddata, and –index options | NONE | |
-truncate | Truncates (deletes all data) from the table (tables) before loading | NONE | |
-loaddata | Loads the data from the .unl file | NONE | |
-index | Indexes the table (tables) | NONE | |
-useint | Use internal database loader (ODBC) instead of DBMS-specific
bulk load utility. This option can be used when the bulk load utilities
are not installed on the system where the Master Data Engine is
installed. For improved performance, use the internal loader. |
NONE | |
-remote | The DBMS is remote from this server | NONE | |
-maxErrs | N | Maximum errors before stopping | NONE |
-commitSize | N | Number of records to process before issuing a database commit operation | NONE |
-otherArgs | args | Additional arguments for native DBMS utilities | NONE |
-noExec | Show SQL statements only; no execution is performed | NONE | |
-verbose | Show progress information | NONE | |
-help | List help information | NONE | |
-version | List version number | NONE | |
-rootDir | MAD_ROOTDIR; location of IBM Initiate Master Data Service software. The environment variable setting for this option (shown in uppercase) can be used in place of the command-line options. | ||
-homeDir | MAD_HOMEDIR; location of Master Data Engine instance. The environment variable setting for this option (shown in uppercase) can be used in place of the command-line options. | ||
-connStr | MAD_CONNSTR; ODBC connection string. The environment variable setting for this option (shown in uppercase) can be used in place of the command-line options. | ||
-dbType | MAD_DBTYPE; native database name. The environment variable setting for this option (shown in uppercase) can be used in place of the command-line options. | ||
-dbServer | MAD_DBSERVER; native database server. The environment variable setting for this option (shown in uppercase) can be used in place of the command-line options. | Optional if not using native | |
-dbName | MAD_DBNAME; native database name. The environment variable setting for this option (shown in uppercase) can be used in place of the command-line options. | Optional if not using native | |
-dbUser | MAD_DBUSER; native database user ID. The environment variable setting for this option (shown in uppercase) can be used in place of the command-line options. | Optional if not using native | |
-dbPass | MAD_DBPASS; native database password. The environment variable setting for this option (shown in uppercase) can be used in place of the command-line options. | Optional if not using native | |
-encoding | MAD_ENCODING; encoding of .unl files; options are: UTF8, UTF16, or LATIN1. The environment variable setting for this option (shown in uppercase) can be used in place of the command-line options. | LATIN1 |
Related concept