madhubunload utility
The madhubunload utility unloads one
or more core (non-entity) tables into .unl files.
Before you run a utility, make sure that you have set the necessary operational server environment variables. For information about the variables, see the operational server environment variables topic.
| Option | Type | Description | Default |
|---|---|---|---|
-objCode |
Object code (DIC, MEM, AUD, REL, TAG, HST, ANL)
for the data to be loaded |
||
-tabList |
List of tables to be loaded. Use ALL for all
tables, or specify individual tables by name (for example, mpi_memstat). |
||
-unlDir |
Identifies the location of .unl files | ||
-commitSize |
Defines the number of records processed between commits | ||
-orderBy |
You can sort .unl files by the column or columns specified in the orderBy parameter. If a column is specified that does not belong to a table that you are trying to unload, then the madhubunload utility fails. | ||
-noExec |
Show SQL statements only, no execution is processed | ||
-verbose |
Shows progress information | ||
-help |
Shows usage information | ||
-version |
Shows version information | ||
-rootDir |
MAD_ROOTDIR; location of the MDM software.
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 |