In the Windows edition of Datareplicator or HiRDB version 08-02 or later, execute this command from the source HiRDB's command prompt.

Function

The hdeprep command analyzes the contents of the extraction definition file, converts it to the internal format, and creates an extraction definition preprocessing file.

Format

hdeprep -f extraction-definition-filename[ -u user-ID/password ]
      [ -k {not_null_unique|unique|none}]

Options

-f extraction-definition-filename

~ <pathname of 1-64 bytes>

Specify the name of the extraction definition file, as an absolute or relative pathname. If you specify a relative pathname, Datareplicator assumes $HDEPATH/relative-pathname as the absolute pathname. In this case, specify the pathname so that the final absolute pathname will not exceed 125 bytes.

-u user-ID/password

user-ID ~ <symbolic name of up to 8 characters>

password ~ <symbolic name of up to 28 characters>

Specify the user ID and password of a user who has the DBA privilege for the source Datareplicator. Both user ID and password are case-sensitive. Do not specify any spaces before or after the delimiter slash (/). For the user ID, specify a symbolic name of 1 to 8 characters; for the password, specify a symbolic name of 1 to 28 characters.

If you omit the -u option, Datareplicator assumes the value of the PDUSER environment variable for the source HiRDB. If this environment variable is not specified, the hdeprep command results in an error during connection establishment processing with the source HiRDB.

-k {not_null_unique|unique|none}

Specify the condition for unique check on the mapping key column.

This value becomes the default when the check clause is omitted in the extraction definition. The specification values and the details of checking are the same as for the check clause of the extraction definition. For details, see the check clause under Explanation of the operands in 5.5 Extraction definition.

If the specified condition is not satisfied, the command terminates abnormally. When this option is omitted, not_null_unique is assumed.

Rules

• Execute the hdeprep command after executing the hdestart -i command.
• You can execute the hdeprep command only while the source HiRDB is active. Execute the hdeprep command while the source Datareplicator is inactive. You can execute the command while the source Datareplicator is active, but when you do so the command's execution results do not become effective at the source Datareplicator until the next time the source Datareplicator is started (the execution results do not take effect at the source Datareplicator during the session in which the command is executed).
• Datareplicator creates the extraction definition preprocessing file as hde_prpfile under $HDEPATH.
• If the hdeprep command terminates normally, it returns 0. If it terminates abnormally, it returns 1.

Notes

• You must execute the hdeprep command in the following cases:
  
  • The hdestart -i command has been executed.
  • The definition of a table subject to extraction processing has been modified at the source HiRDB.
  • The source Datareplicator's extraction definition has been modified.
  • An event control table has been created.
• During analysis of the extraction definition, Datareplicator assumes the character code system specified in the dblocale operand.