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. | ||
| -homeDir | MAD_HOMEDIR; location of the operational server 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 |