The xtrepO command extracts data from a specified table and imports it into a target table on the target system. It can also create a file after data extraction, depending on an operand specification.

The executor must be registered as an ORACLE user. There are also some limitations applicable to a user who is specified in the XTORAUSER environment variable. For details, see (2) in 2.2.3 Specifying environment variables.

Additionally, there are some restrictions on the user who can start HiRDB Dataextractor on the target system. For details, see 2.2.4(3) Specifying /etc/inetd.conf or 6.2.2 Starting and terminating HiRDB Dataextractor when using OSI.

Execute the xtrepO command at the ORACLE server machine that is to be subject to data extraction.

xtrepO [-r [schema-name.][table-identifier]
      [-R [{bin|dat}][,separator-character]]
      [-o [{output-filename|output-directory-name}
           [,{output-filename|output-directory-name}]]]
      [-O [{output-filename|output-directory-name}
           [,{output-filename|output-directory-name}]]]
      [-y]
      [-j RDAREA-name]
      [-h target-host-name]
      [-H single-server's-host-name-or-system-manager's-host-name
        [,front-end-server's-host-name-or-back-end-server's-host-name]]
      [-p port-number]
      [-f front-end-server-name-or-back-end-server-name]
      [-d]
      [-i index-creation-mode]
      [-I [pdload-control-information-environment-variable-name]
         [,pdload-command-line-information-environment-variable-name]
         [,pdload-control-information-file's-source-statement-
           information-environment-variable-name]]
      [-l log-acquisition-mode]
      [-L import-information-filename]
      [-n batch-output-pages-count]
      [-z]
      [-e error-log-filename]
      [-m progress-message-output-interval]
      [-g [lock-information-filename]]
      [-s column-name-specification-filename]
      [-w table-expression-specification-filename]
      [-v null-value-information-filename]
      [-b LOB-input-file-storage-directory-name]
      [-q error-data-filename[,output-lines-count]]
      [-x shell-script-filename]
      [schema-name.]table-identifier

For the most part, the options of the xtrepO command are the same as the xtrep command's options. Only those options that are unique to the xtrepO command are explained below. For details about the other options, see (4) in 4.2.2 xtrep command.

-L import-information-filename

~ <pathname> ((1-255 characters))

Specify the absolute pathname of the import information file. This option is required in the following cases:

• The data type of extracted data is to be changed.
• The length of extracted data is to be changed.

For details about how to specify the import information file, see 5.1.4 Contents of files specified with the xtrepO command.

-g [lock-information-filename]

~ <pathname> ((1-255 characters))

Specify the lock mode. The following explains the relationship between this option and the lock information file:

• When this option is omitted
  HiRDB Dataextractor uses the LOCK statement (always LOCK TABLE table-name IN SHARE MODE) for lock control.
  
• When this option is specified
  HiRDB Dataextractor does not issue the LOCK statement.
  
• When this option is specified and the lock information file is specified
  HiRDB Dataextractor uses the LOCK statement (specified in the lock information file) for lock control. For details about how to specify the lock information file, see 5.1.4 Contents of files specified with the xtrepO command.
  

The valid xtrepO command options depend on the facility to be used after data extraction. To import extracted data into a table, you must omit the -R option; to only create a file without importing data into a table, you must specify the -R option. Table 5-1 shows the combinations of xtrepO command options.

Table 5-1 Combination of xtrepO command options

Option		Facility to be used
Format	Specified information	Import facility	File creation facility
-r	Name of table to be subject to data import	O	N
-R	File creation	I	F
-o	Output filename or directory name (when not deleted)	O	R
-O	Output filename or directory name (when deleted)	O	N
-y	Whether or not to overwrite file	O	O
-j	Name of RDAREA to be subject to data storage	O	N
-h	Name of host to be subject to processing	O	O
-H	Name of host to be subject to data import (when the hosts on source and target systems use different LANs)	O	N
-p	Port number subject to processing	O	O
-f	FES or BES at the destination	O	N
-d	Storage method (value specified with pdload)	O	N
-i	Index creation method (value specified with pdload)	O	N
-I	Name of pdload control information environment variable Name of pdload command line information environment variable Name of pdload control information file's source statement information environment variable	O	N
-l	Log acquisition mode (value specified with pdload)	O	N
-L	Import information filename	O	O
-n	Number of batch output pages (value specified with pdload)	O	N
-z	0-byte characters storage (value specified with pdload)	O	N
-e	Name of error log file	O	O
-m	Progress message output interval	O	O
-g	Lock mode	O	O
-s	Name of column name specification file	O	O
-w	Name of table expression specification file	O	O
-v	Name of null value information file	O	O
-b	Name of LOB input file storage directory	O	O
-q	Name of error data file and number of output lines	O	N
-x	Name of shell script file	N	O
*	Name of table to be subject to data extraction	R	R

F: Option that specifies the facility that is to be used.

I: Must not be specified when data is to be imported into a table. When the -R option is specified, HiRDB Dataextractor executes the file creation facility and does not import data into a table.

R: Required option (if omitted, HiRDB Dataextractor outputs the JXU7300E message, resulting in an error).

O: Optional option.

N: Option that cannot be specified (if specified, HiRDB Dataextractor outputs the JXU7306E or JXU7307E message, resulting in an error).

* Specify [authorization-identifier.]table-identifier.