ID Resolver utility

This utility generates identifiers for XML elements that require them prior to loading into a database.

ID Resolve Syntax Diagram

Notes:

  1. Run the idresgen utility. For information about configuring the Loader package refer to the topic, Configuring Loader package utilities
  2. Filenames specified as parameters for this utility can be preceded by relative or absolute paths.
  3. Note that the wcs.dtd file must be in the same directory as the infile XML file.

Parameter values

-dbname
AIXLinuxSun Solaris Operating EnvironmentWindowsName of the target database
i5/OSiSeriesThis is the database name as displayed in the relational database directory (WRKRDBDIRE)
-dbuser
AIXLinuxSun Solaris Operating EnvironmentWindowsName of the user connecting to the database
i5/OSiSeriesThis is usually the same as the instance user name
-dbpwd
Password for the user connecting to the database
-infile
Name of the input XML document containing table records. Note that the wcs.dtd file must be in the same directory as the infile XML file.
-outfile
Name of the output XML file to be produced; this file can be used as input to the Loader
-method
Method to be used in processing the input file. The utility can treat the input file as though the records do not exist in the database (load) or as if there are already identifiers for the input objects (update). Use the mixed method when some records do not exist in database and some do. The default method is load.
-propfile
Text file containing Java properties in the form of name=value pairs. This file is used to define the look-aside column names for foreign-key identifier lookup and the select predicate for main table (such as CATEGORY and PRODUCT) queries. You can omit entries in this file for tables that have a unique index defined that does not include the identifier. The default file is IdResolveKeys.properties.

This property file can be specified as shown in either of the following examples:

AIXLinuxSun Solaris Operating EnvironmentWindows

-propfileWC_installdir/my_directory/file_name.properties

-propfileWC_installdir/my_directory/file_name


i5/OSiSeries

-propfile WC_userdir/my_directory/file_name.properties

-propfile WC_userdir/my_directory/file_name

If this file exists in the current directory, the same file can be specified as shown in the following example:

-propfile file_name.properties

If this file exists in a directory specified in the classpath system-environment variable, the same file can be specified as shown in the following example:

-propfile file_name

where, my_directory is a user defined directory and file_name is the name of the property file that you want to use.

-poolsize
Number of identifiers to be reserved. The default number is 50.
-maxerror
Number of errors after which the ID Resolver will terminate. This parameter is optional. The default is 1.
-customizer
Name of the customizer property file to be used. The default file is:

AIXLinuxSun Solaris Operating EnvironmentWindowsDB2ConnectionCustomizer.properties
i5/OSiSeriesISeries_RESWCSID_Customizer.properties
If you have configured your instance to use the toolbox driver, then use the Toolbox_RESWCSID_Customizer customizer file provided for the toolbox driver. You must also specify the hostname for the -dbname parameter. The following is an example of invoking the idresgen.sh script:

./idresgen.sh -dbname MY.HOSTNAME.CA -dbuser instance -dbpwd mypass 
-infile /path/infile.xml -outfile /path/outfile.xml -method mixed 
-customizer Toolbox_RESWCSID_Customizer

The customizer property file can be specified as shown in either of the following examples:

AIXLinuxSun Solaris Operating EnvironmentWindows

-customizerWC_installdir/my_directory/file_name.properties

-customizerWC_installdir/my_directory/file_name

i5/OSiSeries

-customizerWC_userdir/my_directory/file_name.properties

-customizerWC_userdir/my_directory/file_name

If this file exists in the current directory, the same file can be specified as shown in the following example:

  -customizer file_name.properties

If this file exists in a directory specified in the classpath system-environment variable, the same file can be specified as shown in the following example:

  -customizer file_name

where, my_directory is a user defined directory and file_name is the name of the property file that you want to use.

-schemaname
Name of the target database schema. This parameter is optional. If this parameter is not specified when running the utility, the utility looks for a name=value pair in the customizer property file that specifies the value of SchemaName. If this pair is present in the property file, the utility uses the value specified. If neither a command-line nor a property-file specification for this parameter exists, the utility defaults to the schema name of the KEYS table in the database.

i5/OSiSeries If neither a command-line nor a property-file specification for the -schemaname parameter exists, the utility defaults to the value of the -dbuser parameter.

-optimize
 -optimize no
The IdResolver will skip duplicate record checking before writing resolved records to the output file. This option allows the user to switch off the optimization feature in
IdResolver.

Feedback