madentload utility

The madentload utility loads the entity tables from .unl files.

This example shows command syntax that can be used to load specific entity tables for an entity type of identity (ID). This example uses the -onepass option, which means that any existing data in the tables is dropped before the data is reloaded.

madentload -entype ID -unlDir $MAD_WORKDIR/unl_ent -tablist mpi_entlink_id mpi_entrule_id  -onepass

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

madentload -entype ID -unlDir $MAD_WORKDIR/unl_ent -tablist ALL -onepass

The -onepass option is used in the examples because the option incorporates the functionality of the -truncate, -loaddata, and -index options.

To load member tables, use the madhubload 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. madentload utility options
Option	Type	Description	Default
`-entType`	entName	Specifies the name of the entity on which to run the operation	NONE
`-rptPfx`		List the entity name prefixes	NONE
`-tabList`	tabName	Table name (or names) to load. Use `ALL` for all tables, or specify individual tables by name (for example, `mpi_entlink_xx` where xx is substituted with the entity type).	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 (or tables)	NONE
`-useint`		Use internal database loader instead of specific DBMS utility. For improved performance, use the internal loader.	NONE
`-remote`		The DBMS is remote from this server	NONE
`-maxErrs`	N	Maximum errors before ending	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.	LATIN1