This command creates document type definition (DTD) and schema files for use with the Loader package.
Notes:
- 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.
- Filenames specified as parameters for this command can be preceded by relative or absolute paths.
Parameter values
- -dbname
Name of the target database
This is the database name as displayed in the relational database directory (WRKRDBDIRE)
- -dbuser
Name of the user connecting to the database
This is usually the same as the instance user name
- -dbpwd
- Password for the user connecting to the database
- -outfile
- Name of the output DTD file
- -infile
- Name of an input file containing a database-table name on each line
- -tablenames
- Names of tables, separated by commas
- -customizer
- Name of the customizer property file to be used. The default file is:
DB2ConnectionCustomizer.properties.
ISeries_GENWCSDTD_Customizer.properties
If you have configured your instance to use the toolbox driver, then use the Toolbox_GENWCSDTD_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 dtdgen.sh script:
./dtdgen.sh -dbname MY.HOSTNAME.CA -dbuser instance -dbpwd mypass -outfile /path/out.dtd method sqlimport -customizer Toolbox_GENWCSDTD_Customizer -infile /path/file.xml
The customizer property file can be specified as shown in the following example:
-customizerWC_installdir/my_directory/file_name.properties
-customizerWC_installdir/my_directory/file_name
-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 name of the database user.
DTD Generate command
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
- -outfile
- Name of the output DTD file
- -infile
- Name of an input file containing a database-table name on each line
- -tablenames
- Names of tables, separated by commas
- -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 the following example:
-customizerWC_installdir\my_directory\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 name of the database user.