ID Resolve command

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

AIXiSeriesLinuxSun Solaris Operating Environment

ID Resolve Syntax Diagram

Notes:

  1. The above diagram is intended primarily as a reference for the command parameters. The command file or script provided for this command and listed in Configuring Loader package commands and scripts acts as a wrapper to the actual Java command and accepts the same parameters; therefore, it is recommended that you use the command file or script rather than invoke the Java command directly.
  2. Filenames specified as parameters for this command can be preceded by relative or absolute paths.

Parameter values

-dbname
AIXLinuxSun Solaris Operating EnvironmentName of the target database
iSeriesThis is the database name as displayed in the relational database directory (WRKRDBDIRE)
-dbuser
AIXLinuxSun Solaris Operating Environment Name of the user connecting to the database
iSeriesThis 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
-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 command 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 Environment

-propfileWC_installdir/my_directory/file_name.properties

-propfileWC_installdir/my_directory/file_name


iSeries

-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 EnvironmentDB2ConnectionCustomizer.properties
iSeriesISeries_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 sqlimport 
-customizer Toolbox_RESWCSID_Customizer

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

 AIXLinuxSun Solaris Operating Environment

-customizerWC_installdir/my_directory/file_name.properties

-customizerWC_installdir/my_directory/file_name

iSeries

-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 command, the command 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 command uses the value specified. If neither a command-line nor a property-file specification for this parameter exists, the command defaults to the schema name of the KEYS table in the database.

iSeries If neither a command-line nor a property-file specification for the -schemaname parameter exists, the command 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.

Windows

ID Resolve Syntax Diagram

Parameter values

-dbname
Name of the target database
-dbuser
Name of the user connecting to the database
 
-dbpwd
Password for the user connecting to the database
-infile
Name of the input XML document containing table records
-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 command 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:-propfileWC_installdir\my_directory\file_name.properties
-propfileWC_installdir\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:
DB2ConnectionCustomizer.properties  

The customizer property file can be specified as shown in either of the following examples:-customizerWC_installdir\my_directory\file_name.properties
-customizerWC_installdir\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 command, the command 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 command uses the value specified. If neither a command-line nor a property-file specification for this parameter exists, the command defaults to the schema name of the KEYS table in the database.
-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.