DTD Generate command

This command creates document type definition (DTD) and schema files for use with the Loader package.

AIXiSeriesLinuxSun Solaris Operating Environment
DTD Generate 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 Environment Name of the target database
iSeries This is the database name as displayed in the relational database directory (WRKRDBDIRE)
-dbuser
AIXLinuxSun Solaris Operating EnvironmentName 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
-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:

AIXLinuxSun Solaris Operating EnvironmentDB2ConnectionCustomizer.properties.

iSeriesISeries_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:

 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 name of the database user.

WindowsDTD Generate command

DTD Generate 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
-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.