IBM InfoSphere Master Data Management, Version 10.1The madentload utility loads the entity tables from .unl files.
| 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_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 (or tables) before loading | NONE | |
| -loaddata | Loads the data from the .unl file | NONE | |
| -index | Indexes the table (or tables) | NONE | |
| -useint | Use internal database loader instead of DBMS-specific 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 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
