The xtrep 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.

There is no specific limitation to what an executor can do, except that the user specified in the PDUSER environment variable must have certain privileges. 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 (3) in 2.2.4 Files required in order to use HiRDB Dataextractor or 6.2.2 Starting and terminating HiRDB Dataextractor when using OSI.

Execute the xtrep command at the HiRDB server machine that is to be subject to data extraction. This server machine depends on the HiRDB system to be connected (i.e., a HiRDB/Single Server or a HiRDB/Parallel Server). The following shows the server machine at which the xtrep command is to be executed:

• HiRDB/Single Server
  Server machine at which the single server is located
  
• HiRDB/Parallel Server
  Server machine at which one of the following servers is located:
  
  • System manager
  • Front-end server
  • Back-end server
  • Dictionary server

xtrep [-r [authorization-identifier.]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-file-name]
      [-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]
      [authorization-identifier.]table-identifier

-r [authorization-identifier.]table-identifier

Specify the name of the table that is to be subject to data import. The -r and -R options are mutually exclusive. If both options are omitted or if the authorization identifier is omitted, HiRDB Dataextractor assumes as follows:

• -r option omitted

authorization-identifier:

Authorization identifier specified for the table that is to be subject to extraction:

HiRDB Dataextractor assumes the authorization identifier specified for the table that is to be subject to extraction.

No authorization identifier specified for the table to be subject to extraction:

HiRDB Dataextractor assumes the value set in the PDUSER environment variable that is used by HiRDB Dataextractor on the data target system.

table-identifier:

HiRDB Dataextractor assumes the table identifier of the table that is to be subject to extraction.

• authorization-identifier only omitted
  HiRDB Dataextractor assumes the value set in the PDUSER environment variable that is used by the HiRDB Dataextractor on the data target system.
  

Notes

• The specified authorization identifier and table identifier are assumed to be in all uppercase letters. To have them handled as being case sensitive, separately enclose each of them (authorization identifier and table identifier) in double quotation marks ("), and then enclose them each separately or both together in single quotation marks (').
• If the table identifier contains a space, enclose the entire table identifier in double quotation marks (") and then enclose it in single quotation marks (').

Examples

• The following specifications are both regarded as USER01.TABLE01:

user01.table01
 
"user01"."table01"

• The following specifications are both regarded as user01.table01:

'"user01"."table01"'
 
'"user01"'.'"table01"'

-R [{bin|dat}][,separator-character]

To only create a file after data extraction, use this option to specify the format of the file that is to be created. When this option is specified, HiRDB Dataextractor does not store the extracted data in a table on the target system. To store the data into a target table, omit this option. The -R and -r options are mutually exclusive.

Use the -o option to specify the name of the file that is to be created. For details about the file format, see (4) in 4.2.4 Contents of files specified with the xtrep command.

To execute a user-created shell script after file creation, use the -x option to specify the filename of the shell script.

bin

Create the file in binary format.

HiRDB Dataextractor stores the extracted data in the specified file exactly in the same format as in the HiRDB database.

dat

Create the file in DAT format.

HiRDB Dataextractor converts the extracted data, including numeric data, to characters and then stores them in the specified file. This is referred to commonly as the CSV format.

separator-character ~ <character string> ((1 character)) <<comma (,)>>

If you have specified dat, specify the character you want to use as the separator between data items. If you have specified bin, you cannot specify a separator character.

If you specify dat but omit specification of a separator character, the comma (,) is assumed. To specify a space or a character that has special meaning to the shell (such as a vertical bar (|)), enclose the character in double quotation marks (").

To use the created file as an input file to the target database system on the target system, you must specify the separator character in accordance with the conventions stipulated by the target database system.

Note

When you specify a separator character, do not place spaces before or after the preceding comma (,).

Examples

• Correct

-R dat,","

• Incorrect

-R dat, ","

There is a space before and after the comma.

-R,","

When bin is specified (or assumed as the default), a separator character cannot be specified.

-o [{output-filename|output-directory-name} [,{output-filename|output-directory-name}]...]

~ <pathname> ((1 length of one name in characters 255) x number of files 511 characters in all))

output-filename: Enter any character other than the forward slash (/) at the end of the specified value.

output-directory-name: Enter the forward slash (/) at the end of the specified value.

If a directory name is specified, HiRDB Dataextractor creates a file by assigning a unique filename.

This option specifies that the extracted data is to be output to a specified output file. It uses a filename or directory name as the output destination. Whether or not the data is to be imported into a table after file creation depends on the -R option.

-R option specified

If the -R option is specified, HiRDB Dataextractor creates the specified output file(s) and does not import the data into a target table. You use the -R option to specify the format of the output file. The output file is created at the following host on the file creation system:

• -h option specified: Host specified with the -h option
• -h option omitted: Host specified in the XTHOST environment variable

Note that if you create a binary-format file for storing SGMLTEXT-type columns, the data cannot be imported into a HiRDB table.

-R option omitted

If the -R option is omitted, HiRDB Dataextractor imports the data into the target table after it creates the output file. The output file is created in binary format at the host located at the following server of the importing HiRDB:

• HiRDB/Single Server: Single server
• HiRDB/Parallel Server:
  -f option specified: FES or BES specified in the -f option
  -f option omitted: FES or BES that is assumed as the default
  

If you specify the -o option, HiRDB Dataextractor retains the created output file and the file created by HiRDB's database load utility after the import processing; you can use this output file as a backup. To re-create a HiRDB table on the basis of a created output file in the event of an error, use HiRDB's database load utility.

To delete the output file after the import processing, specify the -O option. The -o and -O options are mutually exclusive.

If you specify the -o option, use the -y option to specify the method for handling an existing output file.

If you omit the -o option, HiRDB Dataextractor creates the file with a unique name under the /opt/HIRDBXT/spool directory; for details, see Table 2-3 Directories and files created by HiRDB Dataextractor.

Notes

• The total length of the XTTMPDIR environment variable and output filenames must not exceed 255 characters.
• If the specified value contains a back slash (\), enclose the specified value in double quotation marks (").
• You can specify multiple filenames and directory names in the -o option only if the HiRDB Dataextractor on the import or file creation system supports this feature. If this feature is not supported, HiRDB Dataextractor outputs the JXU7001E message and terminates with an error on the import or file creation system. If the HiRDB Dataextractor on the source system does not support this feature, it will regard the specified filenames or directory names as a single filename.

Example

xtrep -o /hd001/,/hd002/ TBL_NAME

This example creates files with unique names under /hd001/ and /hd002/ and imports data into the target table.

-O [{output-filename|output-directory-name} [,{output-filename|output-directory-name}]...]

~ <pathname> ((1 length of one name in characters 255) x number of files 511 characters in all))

output-filename: Enter any character other than the forward slash (/) at the end of the specified value.

output-directory-name: Enter the forward slash (/) at the end of the specified value.

If a directory name is specified, HiRDB Dataextractor creates a file by assigning a unique filename.

This option specifies that the extracted data is to be output to a specified output file. It uses a filename or directory name as the output destination. HiRDB Dataextractor imports the data into the target table after creating an output file and automatically deletes the output file upon completion of the import processing.

The output file is created in binary format at the host located at the following server of the importing HiRDB:

• HiRDB/Single Server: Single server
• HiRDB/Parallel Server:
  -f option specified: FES or BES specified in the -f option
  -f option omitted: FES or BES that is assumed as the default
  

To retain the output file upon completion of import processing, specify the -o option; to delete it, specify the -O option. The -o and -O options are mutually exclusive. When the -R option is specified, the -O option cannot be specified.

If you specify the -O option, use the -y option to specify the method for handling an existing output file. When the -O option is specified, the filename of the created output file is the same as when the -o option is specified.

Notes

• The total length of the XTTMPDIR environment variable and output filenames must be no greater than 255 characters.
• If the specified value contains a back slash (\), enclose the specified value in double quotation marks (").
• You can specify multiple filenames and directory names in the -O option only if the HiRDB Dataextractor on the import or file creation system supports this feature. If the feature is not supported, HiRDB Dataextractor outputs the JXU7001E message and terminates with an error on the import or file creation system. If the HiRDB Dataextractor on the source system does not support this feature, it will regard the specified filenames or directory names as a single filename.

-y

Use this option to specify whether or not an existing file is to be overwritten when a file to be created already exists during file creation. If you specify the -y option, HiRDB Dataextractor deletes the existing file and then outputs the data to the file. If you omit the -y option, HiRDB Dataextractor outputs a message and terminates the processing. You can specify this option only when the -o, -O, or -b option is specified.

The -y option is applicable to the following files:

• Output file (created when the -o or -O option is specified)
• LOB input file storage directory and LOB input files (created when the table subject to data extraction contains data for BLOB columns)

Note that HiRDB Dataextractor may not be able to overwrite the file, depending on the file mode.

-j RDAREA-name

~ <identifier> ((1-30))

To store the data into a row-partitioned table by RDAREA, specify the name of the RDAREA. If you have specified the -R option, you cannot specify the -j option. If you omit this option, HiRDB Dataextractor will store the data by table.

Notes

• An RDAREA name is assumed to be all uppercase letters. To have it handled as being case sensitive or to specify an RDAREA name containing a space, enclose the RDAREA name in double quotation marks (") and then enclose it in single quotation marks (').
• This option is applicable only if the HiRDB Dataextractor on the import or file creation system supports this feature. If the feature is not supported, HiRDB Dataextractor issues the JXU7001E message and terminates with an error on the import or file creation system.

-h target-host-name

Specify the name of the host to which the extracted data is to be sent. You can specify the FQDN instead of the host name.

If you are importing extracted data into a table, specify the host name at the following server:

• HiRDB/Single Server: Single server (SDS)
• HiRDB/Parallel Server: System manager (MGR)

In the case of file creation, specify the name of the host to be used to create the file.

When the -h option is omitted, HiRDB Dataextractor assumes the value set in the XTHOST environment variable. Specify this host name in /etc/hosts on the data source system. For details about the specification, see 2.2.4 Files required in order to use HiRDB Dataextractor.

Notes

• If the host on the source system uses a different LAN than the host on the target system, executing the xtrep command with this option specified will result in a connection establishment error. In such a case, re-execute the command with the -H option specified. The -h and -H options are mutually exclusive.
• The host at the system manager and the host at the target server to which data is to be sent (front-end or back-end server) must be accessible from the host on the source system.
• If the target HiRDB uses the system switchover facility, specify the name of the host that inherits the IP address.

-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]

Specify the name of the host to which the extracted data is to be imported. You can specify the FQDN instead of the host name.

You use this option when the host on the source system uses a different LAN than the host on the target system.

Specify the name(s) of the host(s) located at the following server(s) on the data target system:

• HiRDB/Single Server
  Single server (SDS)
  
• HiRDB/Parallel Server
  System manager (MGR) and the target server to which the data is to be sent (front-end server (FES) or back-end server (BES))
  If you omit the host name of the FES or BES, HiRDB Dataextractor assumes that the MGR's host contains the applicable FES or BES.
  

When the -H option is omitted, HiRDB Dataextractor assumes the value set in the XTXHOST environment variable. Specify the host name in /etc/hosts on the data source system. For details about the specification, see 2.2.4 Files required in order to use HiRDB Dataextractor.

Notes

• The FES or BES host specified with this option must contain the following FES or BES:
  -f option specified: FES or BES specified with the -f option
  -f option omitted: FES or BES assumed as the default when the -f option is omitted
  
• The -h and -H options are mutually exclusive.
• If you specify the -R option, you cannot specify the -H option.
• The host at the MGR and the host at the target server to which data is sent must be accessible from the host on the source system.
• If the target HiRDB uses the system switchover facility, specify the name of the host that inherits the IP address.

-p port-number

~ <unsigned integer> ((1025-65535))

Specify the port number of the HiRDB Dataextractor that is located at the following host specified with the -h or -H option:

• HiRDB/Single Server: Host at the single server
• HiRDB/Parallel Server: Host at the system manager and at the target server to which data is to be sent
• File creation: Host used to create the file

If the -p option is omitted, HiRDB Dataextractor assumes the value set in the XTPORTNO environment variable. Specify the port number that has been assigned to the HiRDB Dataextractor in /etc/services/ on the import or file creation system. For details about the specification, see 2.2.4 Files required in order to use HiRDB Dataextractor.

Note

• If the system manager and the target server to which data is to be sent are located at different hosts, you must assign the same port number to the HiRDB Dataextractors running on these hosts.

-f front-end-server-name-or-back-end-server-name

For a HiRDB/Single Server, specify the name of the front-end server (FES) or back-end server (BES) at the data transmission target. If you omit this option, HiRDB Dataextractor assumes one of the following server names, depending on the data storage method:

• Storage by table
  HiRDB Dataextractor assumes the name of the first FES specified in the pdstart command in the HiRDB system common definitions (pdsys). For details about the HiRDB system common definitions, see the HiRDB System Definition manual.
  
• Storage by RDAREA
  HiRDB Dataextractor assumes the name of the BES that contains the RDAREA that stores the data.
  

-d

Specify the data storage method for importing the extracted data into a table.

When you specify this option, HiRDB Dataextractor deletes all existing data from the table and then stores the extracted data. If you omit this option and the table already contains data, HiRDB Dataextractor adds the extracted data to the table without deleting the existing data.

The value of this option is that of the -d option specified for HiRDB's database load utility that is started by HiRDB Dataextractor. If this option is omitted and an error occurs during data import processing, HiRDB Dataextractor may not be able to restore the original data unless a or p is specified in the -l option.

-i index-creation-mode

Specify the index creation mode to be used when the extracted data is imported into a table. When this option is omitted, c is assumed. The value of this option is that of the -i option specified for HiRDB's database load utility (pdload) that is started by HiRDB Dataextractor:

c

Use the batch index creation mode. The utility creates indexes in the batch mode after table creation processing.

n

Use the index information output mode. The utility only outputs index information to index information files. When you specify this mode, you must use HiRDB's database reorganization utility to re-create the indexes.

s

Use the index update mode. The utility updates indexes each time a row of data is stored.

x

Use the index information output suppression mode. The utility does not update indexes or output index information to index information files.

If you specify c in the -i option and an error occurs during batch index creation, or if you specify x in the -i option, the table's row data is correct, but the indexes are invalid (not created). In such a case, you need to re-create each index using one of the following methods:

• Load zero data items with HiRDB's database load utility
  Execute the command in the addition mode with c specified in the -i option.
  
• Re-create the index with HiRDB's database reorganization utility
  Execute the command with ikrc specified in the -k option.
  

-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]

((6-10 characters))

You can specify desired pdload parameters by specifying the names of one or more of the environment variables listed below. You can specify these environment variable names in any order, delimited by the comma (,); you may not specify the same environment variable name more than once.

• pdload control information environment variable (XTPDCFxxxx)
• pdload command line information environment variable (XTLPRMxxxx)
• pdload control information file's source statement information environment variable (XTPDSRxxxx)

For details about each environment variable, see (2) Specification of environment variables in 2.2.3 Specifying environment variables.

Notes

• If you omit both this option and the XTPDCFPATH environment variable, pdload creates the index information file and LOB middle file under /tmp. If the target table contains an index or BLOB columns, temporary files are output to /tmp proportionally to the amount of data. If /tmp does not have sufficient space, the entire system may be affected adversely.
• You can use this option as a countermeasure in the event of a pdload error due to the following causes:
  The target table contains no indexes, but a control information file containing the idxwork or index statement was specified.
  The target table contains no BLOB columns, but a control information file containing the lobmid statement was specified.
  Create a control information file appropriate to the table definition for each table on the target system and set it in an XTPDCFxxxx environment variable. When you execute HiRDB Dataextractor, use this option to specify the control information file corresponding to the target table.
  
• You can use this option only if the HiRDB Dataextractor on the target or file creation system supports this function. If the function is not supported, HiRDB Dataextractor displays the JXU7001E message at the target or file creation system, resulting in an error.

-l log-acquisition-mode

Specify the log acquisition mode to be used during import of extracted data into a table. When this option is omitted, HiRDB Dataextractor assumes p. The value of this option is that of the -l option specified for HiRDB's database load utility that is started by HiRDB Dataextractor.

a

Use the log acquisition mode. The utility acquires log information required for rollback and rollforward.

p

Use the pre-update log acquisition mode. The utility acquires log information required for rollback, but not for rollforward.

n

Use the no-log mode. The utility does not acquire log information.

For details about how to handle the pre-update log acquisition mode and the no-log mode, see the HiRDB System Operation Guide.

-L import-information-file-name

~ <path name> ((1-255 characters))

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

• When the type of extracted data is converted
• When the length of extracted data is changed
• When pdload is used to load a file created by extracting the SGMLTEXT type

For details about specifying the import information file, see 4.2.4 Contents of files specified with the xtrep command.

-n batch-output-pages-count

~ <unsigned integer> ((8-4096)) <<10>>

To import extracted data into a table, specify the number of pages to be output to the table in the batch mode. The value of this option is that of the -n option specified for HiRDB's database load utility that is started by HiRDB Dataextractor.

-z

Specify this option to store data with a length of zero in variable-length character strings, variable-length national character strings, and variable-length mixed character strings during import of extracted data into a table. If this option is omitted and the extracted data contains a data item with a length of zero, HiRDB's database load utility (pdload) results in an invalid input data error. The value of this option is that of the -z option specified for HiRDB's database load utility that is started by HiRDB Dataextractor.

-e error-log-filename

Specify the absolute pathname of the error log file to which log messages are to be output. If the specified file is not found, HiRDB Dataextractor creates one. There is no need to create this file beforehand.

When you omit this option, HiRDB Dataextractor creates a file with a unique name in the /opt/HIRDBXT/spool. For details, see Table 2-3.

-m progress-message-output-interval

~ <unsigned integer> ((1-1000)) <<10>>

Specify the interval at which messages indicating the data extraction status are to be output; this interval is specified in units of 1000 lines. These messages are output to the error log file and the standard output.

-g

[lock-information-file-name]

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

Specify the lock mode. When this option is specified, any entry of the LOCK statement is ignored. When you omit this option, you must use the LOCK statement to lock resources. For the relationship between the -g option and the lock mode, see 4.1.1 Conventions for extraction.

The relationship between this option and the lock information file is as follows:

• 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 4.2.4 Contents of files specified with the xtrep command.
  

-s column-name-specification-filename

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

Specify the absolute pathname of the column name specification file. This option is required in the following cases:

• Number of columns on the source system and the target system are not the same.
• Columns are resorted.
• Data is extracted with a line-by-line interface.
• Columns of the SGMLTEXT type are extracted.

For details about how to specify a column name specification file, see 4.2.4 Contents of files specified with the xtrep command.

-w table-expression-specification-filename

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

Specify the absolute pathname of the table expression specification file. This option is required in the following cases:

• Rows for extraction are selected on the basis of specified conditions.
• Extraction results are sorted.

For details about how to specify a table expression specification file, see 4.2.4 Contents of files specified with the xtrep command.

-v null-value-information-filename

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

Specify the absolute pathname of the null value information file. Specify a null value information file in the following cases:

• The default null value is to be changed.
• The data format and null value import method need to be specified in order to output repetition columns to a file.

For details about how to specify the default null value and the null value information file when this option is omitted, see (3) in 4.2.4 Contents of files specified with the xtrep command. For details about the data format for repetition columns and the null value import method, see (6) in 3.1.1 Extracting selected data.

-b LOB-input-file-storage-directory-name

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

Specify the name of the directory for storing LOB input files.

If the extracted data contains LOB data, this option specifies the name of the directory for storing the LOB input files that are created to process the LOB data on the data import or file creation system. To store BLOB-column data in the same output file as for non-BLOB data without creating LOB input files, specify the XTLOBKIND environment variable.

To retain the LOB input file storage directory after completion of import processing, specify the -o option; to delete the LOB input file storage directory upon completion of import processing, specify the -O option. The -o and -O options are mutually exclusive.

If you specify the -o or -O option and a file to be created already exists, use the -y option to specify how to handle the file.

If the -R option is specified, HiRDB Dataextractor creates the LOB input file storage directory at the following host on the file creation system:

• -h option specified: Host specified with the -h option
• -h option omitted: Host specified in the XTHOST environment variable

If the -R option is omitted, HiRDB Dataextractor creates the LOB input file storage directory at the host located at the following HiRDB server on the target system:

• HiRDB/Single Server: Single server
• HiRDB/Parallel Server:
  -f option specified: FES or BES specified with the -f option
  -f option omitted: FES or BES that is the default when the -f option is omitted
  

When this option is omitted, HiRDB Dataextractor creates files with unique names in the /opt/HIRDBXT/spool directory. For details, see Table 2-3 Directories and files created by HiRDB Dataextractor.

Note

• If the specified value contains a back slash (\), enclose the specified value in double quotation marks (").

-q error-data-filename[,output-lines-count]

error-data-file-name ~ <pathname> ((1-255 characters))

To output invalid row data to an error data file, specify the name of the error data file that is to be created by HiRDB's database load utility (pdload).

output-lines-count ~ <unsigned integer> ((1-4294967295))

Specify a maximum number of output lines of erroneous row data. If you omit this information, pdload assumes 100.

The error data file is created at the host located at the following server on the importing HiRDB system:

• HiRDB/Single Server: Single server
• HiRDB/Parallel Server:
  -f option specified: FES or BES specified with the -f option
  -f option omitted: FES or BES that is the default when the -f option is omitted
  

The created error data file will remain after the import processing is completed, so you can modify the row data in the error data file and use the file as an input data file for pdload.

When this option is omitted, erroneous row data is not output. If the specified error data file already exists, HiRDB Dataextractor overwrites the existing file. The name of the error data file is determined by this option and the value set in the XTTMPDIR environment variable. Table 4-2 shows the name of the error data file to be created.

Table 4-2 Name of the error data file to be created

-q option	XTTMPDIR	Name of error data file
Specified	Specified	$XTTMPDIR/error-data-filename
	Omitted	/opt/HIRDBXT/spool/error-data-filename
Omitted	--	-- (Not created)

Notes

• The total length of the XTTMPDIR environment variable and the filename must not exceed 255 characters.
• This option is applicable only if the HiRDB Dataextractor on the import or file creation system supports this feature. If the feature is not supported, HiRDB Dataextractor outputs the JXU7001E message and results in an error on the import or file creation system.

-x shell-script-filename

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

To execute a user-created shell script after file creation, specify the absolute pathname of the shell script file. This option is applicable only when the -R option is specified.

When this option is specified, HiRDB Dataextractor processing is placed on hold until the shell script processing is completed. If the shell script's exit status is not 0, HiRDB Dataextractor outputs the JXU7010E error message.

The specified shell script must satisfy the following conditions:

• The shell script is created at a server machine on the file creation system.
• HiRDB Dataextractor's executor specified in /etc/inetd.conf on the file creation system can execute the shell script.
• The shell script's exit status is in the range of -128 to 127.
• The shell script can use the standard output and standard error output, but not the standard input.

[authorization-identifier.]table-identifier

Specify the table that is to be subject to data extraction. When the authorization identifier is omitted, HiRDB Dataextractor assumes the command executor's authorization identifier in the PDUSER environment variable.

Notes

• You must specify this information at the end of the xtrep command.
• The specified authorization identifier and table identifier are assumed to be in all uppercase letters. To have them handled as being case sensitive, separately enclose each of them (authorization identifier and table identifier) in double quotation marks ("), and then enclose them each separately or both together in single quotation marks (').
• If the table identifier contains a space, enclose the entire table identifier in double quotation marks (") and then close it in single quotation marks (').

Examples

• The following specifications are both regarded as USER01.TABLE01:

user01.table01
 
"user01"."table01"

• The following specifications are both regarded as user01.table01:

'"user01"."table01"'
 
'"user01"'.'"table01"'

The valid xtrep 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 4-3 shows the combinations of xtrep command options.

Table 4-3 Combinations of xtrep 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 mode (value specified with pdload)	O	N
-I	Names of pdload control information environment variables, pdload command line information environment variables, and pdload control information file's source statement information environment variables (XTPDCFxxxxx, XTLPRMxxxxx, XTPDSRxxxxx)	O	N
-l	Log acquisition mode (value specified with pdload)	O	N
-L	Name of import information file	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.