When the OS being used is UNIX, specify HiRDB Dataextractor's environment variable information setup file; for details, see 2.2.3 Specifying environment variables.

When the OS being used is Windows, see B. Functional Differences with Windows.

When the OS being used is UNIX, and the TCP/IP protocol is used, you must specify your HiRDB Dataextractor's service name and port number in /etc/services.

For the port number, specify a number that is unique within the network and that is not being used by any other service.

When the OS being used is Windows, see B. Functional Differences with Windows.

The following is an example of an entry to be registered.

/etc/services
 
# @(#) services  1.2  30/06/95
#
#UNIX specific services, Internet style
ftp   21/tcp
                :
                :
hirdbxt 20052/tcp  #HiRDB Dataextractor...added

When the OS being used is UNIX and the TCP/IP protocol is used, HiRDB Dataextractor is started from the /etc/inetd.conf configuration file. Therefore, you must specify information about HiRDB Dataextractor in /etc/inetd.conf.

If you modify the contents of /etc/inetd.conf, either you must restart the machine or the superuser must issue a signal.

When the OS being used is Windows, the specification of /etc/inetd.conf is unnecessary.

Table 2-13 shows the information to be specified in /etc/inetd.conf.

Table 2-13 Information to be specified in /etc/inetd.conf

* The specified user can start HiRDB Dataextractor. Note the following:

• If the specified user is not a superuser and an error occurs in HiRDB Dataextractor, a core dump will not be output.
• In the case of file creation from extracted data, if the file to be created (including a LOB input file) already exists, the user must have the write privilege. You can specify the file mode for the created file with the XTFPERMIT and XTDPERMIT environment variables. For details about how to specify the environment variables, see (2) in 2.2.3 Specifying environment variables.
• If HiRDB Dataextractor is linked with XDM/XT, and data is extracted from an ORACLE database, the user must be registered in ORACLE.

Specification example of /etc/inetd.conf

hirdbxt stream tcp nowait user01
        /opt/HIRDBXT/bin/pxtcntl
        pxtcntl /usr/home/user01/xtenv1

Note

Specify this information in one line.

Example of issuing a signal when /etc/inetd.conf is modified

kill -HUP inetd-process-ID

When you use the OSI protocol to start HiRDB Dataextractor automatically, you must specify the xtstart command execution shell. For details about how to specify the xtstart command execution shell, see (1)(a) Automatic startup in 6.2.2 Starting and terminating HiRDB Dataextractor when using OSI.

To use the OSI protocol, you must specify the information required for communication in the communication configuration definition information file. The following is the specification format:

Format

set T_selector=local-host's-T-selector-value

Rules

• Specify one set statement in one line.
• Each line can contain only one set statement.
• Do not place any spaces before or after the equals sign (=).
• A comment begins with the number sign (#) and ends at the end of the line.

T_selector=local-host's-T-selector-value

~ <hexadecimal> ((2-64 characters))

Specify the local system's T selector value, in the format x'hexadecimal-number' or X'hexadecimal-number'.

Relationship with the XNF network definitions

The following explains the relationship between the communication configuration definitions and the VOS3 XNF E2 network definitions. The local host's selector value specified in the T_selector operand of the set communication configuration definition statement corresponds to the T selector value specified in the T_SELECTOR operand of the ULE XNF E2 network definition statement.

For details about the VOS3 XNF E2 network definitions, see the VOS3 XNF E2 Network Definition manual.

If the OS being used is UNIX, and the TCP/IP protocol is used, you must specify the target host name in the source system's /etc/hosts.

To import extracted data into a table, specify the name of the host at which the following server is located:

• Single server for a HiRDB/Single Server
• System manager for a HiRDB/Parallel Server

To create files from extracted data, specify the name of the host name at the file creation system.

If the OS being used is Windows, see B. Functional Differences with Windows.

The following is an example of an entry to be registered:

/etc/hosts
       :
       :
160.16.150.120 HOST2
       :
       :

When HiRDB Dataextractor is linked with XDM/XT and data is extracted from HiRDB, to use the function for specifying SQL statements that are to be issued, you set a table name information file in the source system, if necessary, and specify its file name in the XTTBLxxxx environment variable.

In the table name information file, specify the table expression up to the WHERE clause of the SELECT statement.

For details about specifying table expressions in the SELECT statement, see the HiRDB SQL Reference manual.

To use the function for specifying parameters of the HiRDB database load utility (pdload) when data is imported into a HiRDB table, you set a pdload command line information file in the target system, if necessary, and specify its file name in the XTLPRMxxxx environment variable.

In the pdload command line information file, specify the pdload command line parameters. You must ensure that none of the parameters listed below is specified; if any of these parameters is specified, operations cannot be guaranteed:

• Target table name (authorization identifier, table identifier)
• Control information file name
• -b option (for entering binary-format data)
• -k option (BLOB data format)
• -v option (null value information)
• -w option (for entering binary-format data created by the database reorganization utility)
• -c option (information about a column structure information file)

For details about the command line parameters, see the HiRDB Command Reference manual.

To use the function for specifying pdload parameters when data is imported into a HiRDB table, you set the pdload control information file's source statement information file in the target system, if necessary, and specify its file name in the XTPDSxxxx environment variable.

In the pdload control information file's source statement information file, specify the source statements that are specified in the control information file, which is a parameter of pdload. You must ensure that none of the parameters listed below is specified; if any of these parameters is specified, operations cannot be guaranteed:

• RDAREA name
• Server name, host name
• Input file name
• Error information file name