madhubload utility

The madhubload utility loads one or more virtual MDM tables from .unl files.

This example shows command syntax that can be used to load specific member tables. This example uses the -onepass option, which means that any existing data in the tables is dropped before the data is reloaded.

madhubload -objCode MEM -unlDir $MAD_WORKDIR/unl_mem -tabList mpi_memhead mpi_memattr mpi_membktd mpi_memcmpd -onepass

This example shows the command syntax that is used to process an initial data load.

madhubload -objCode MEM -unlDir $MAD_WORKDIR/unl_mem -tabList ALL -onepass

In both examples, the -onepass option is used because that option incorporates the functionality of the -truncate, -loaddata, and -index options.

To load entity tables, use the madentload utility.

Before you run a utility, make sure that the necessary operational server environment variables are set. For information about the variables, see the operational server environment variables topic.

Table 1. madhubload utility options
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 recreating the table The `-truncate` option is different from the SQL TRUNCATE command in that `-truncate` drops and recreates the table	NONE
`-loaddata`		Loads the data from the .unl file	NONE
`-index`		Indexes the table (tables)	NONE
`-useint`		Use internal database loader (ODBC) instead of the specific DBMS bulk load utility. This option can be used when the bulk load utilities are not installed on the system where the operational server is running. 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 processed	NONE
`-verbose`		Show progress information	NONE
`-help`		List help information	NONE
`-version`		List version number	NONE
`-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.	NONE