Examples

(a) Environment on the data source system (HOST1)

Table definition

Table name	Column names and attributes
TORA01	C01 CHAR(10), C02 NUMBER(10,8), C03 DATE
TORA02	C01 CHAR(10), C02 NUMBER(10,8), C03 NUMBER

Specification of environment variables

$ORACLE_BASE /ORACLE8/ORACLE
$ORACLE_HOME /ORACLE8/ORACLE/product/8.1.6
$ORA_NLS33   /ORACLE8/ORACLE/product/8.1.6/ocommon/nls/admin/data
$NLS_LANG    Japanese_Japan.JA16SJIS
$ORACLE_SID  hds1
$ORACLE_TERM hp
$XTORAUSER   "user01"/"user01"
$PATH        /opt/HIRDBXT/bin
$LANG        ja_JP.SJIS
$XTHOST      HOST2
$XTPORTNO    20052

Specification in /etc/hosts at the importing host

        :
        :
160.16.150.120  HOST2
160.16.150.121  HOST3
        :
        :

(b) Environment on the data target system (HOST2)

Table definition

Definition of the table with authorization identifier user01

CREATE TABLE T01(C01 CHAR(10),C02 DEC(10,8),C03 DATE,C04 TIME)
CREATE TABLE T02(C01 CHAR(10),C02 DEC(10,8),C03 INT, C04 INT)

Definition of the table with authorization identifier user02
```
CREATE FIX TABLE T03(C01 CHAR(10),C02 DEC(10,8),C03 TIME)
```

Definition of port in /etc/services

                      :
                      :
hirdbxt1 20052/tcp    # HiRDB Dataextractor
hirdbxt2 50000/tcp    # HiRDB Dataextractor
                      :
                      :

Definition for HiRDB Dataextractor startup in /etc/inetd.conf

                      :
                      :
hirdbxt1 stream tcp nowait user01
/opt/HIRDBXT/bin/pxtcntl pxtcntl /usr/home/user01/xtenv1
hirdbxt2 stream tcp nowait user02
/opt/HIRDBXT/bin/pxtcntl pxtcntl /usr/home/user02/xtenv2
                      :
                      :

Specification of environment variables in the environment variable information specification file

Environment variable information specification file for service name hirdbxt1 and port number 20052 (/usr/home/user01/xtenv1)
```
set PDDIR=/HiRDB2
set PDCONFPATH=/HiRDB2/conf
set PDUSER="user01"/"user01"
set LANG=ja_JP.SJIS
```
Environment variable information specification file for service name hirdbxt2 and port number 50000 (/usr/home/user02/xtenv2)
```
set PDDIR=/HiRDB2
set PDCONFPATH=/HiRDB2/conf
set PDUSER="user02"/"user02"
set LANG=ja_JP.SJIS
```

(c) Environment on the file creation system (HOST3)

Definition of port in /etc/services

                     :
                     :
hirdbxt 20052/tcp    # HiRDB Dataextractor
                     :
                     :

Definition for HiRDB Dataextractor startup in /etc/inetd.conf

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

Specification of environment variables in the environment variable information specification file

Environment variable information specification file for service name hirdbxt and port number 20052 (/usr/home/user01/xtenv)
```
set XTTMPDIR=/usr/home/user01/data
set LANG=ja_JP.SJIS
```

Specify the xtrepO command on the data source system.

(a) Example 1

Copy table TORA01 at HOST1 into table T01 at HOST2. Specify the following options:

Port number used by the HiRDB Dataextractor on the target system is 20052.
Add the data without deleting any existing data.
Acquire a pre-update log.
Number of batch output pages is 10.
Output progress message every 10,000 lines.
Lock the table subject to extraction.
Do not change the default null value.

Command specification

xtrepO -r T01 -s /usr/home/user01/clm TORA01

Contents of /usr/home/user01/clm

C01,C02,C03,C04

(b) Example 2

Copy table TORA02 at HOST1 into table T02 at HOST2. Specify the following options:

Port number used by the HiRDB Dataextractor on the target system is 20052.
Delete all existing data and then add the new data.
Do not acquire a log.
Number of batch output pages is 255.
Output progress message every 100,000 lines.
Do not lock the table subject to extraction.
Extract rows with the value '0000010000' in column C01 and set the literal 0 in column C04.
Set the default null value for column C01 to 'FFFFFFFFFF'.

Command specification

xtrepO -r T02 -d -l n -n 255 -m 100 -g -s /usr/home/user01/clm
-v /usr/home/user01/null -w /usr/home/user01/whr TORA02

Contents of /usr/home/user01/clm

C01,C02,C03,0

Contents of /usr/home/user01/whr

WHERE C01<='0000010000'

Contents of /usr/home/user01/null

1=NUM=('FFFFFFFFFF')

(c) Example 3

Copy table TORA01 at HOST1 into table T03 at HOST2. Specify the following options:

Port number used by HiRDB Dataextractor is 50000.
Delete all existing data.
Acquire a pre-update log.
Number of batch output pages is 40.
Obtain the execution results in /tmp/xtrep_log.
Output progress message every 10,000 lines.
Lock the table subject to extraction.
Do not change the default null value.

Command specification

xtrepO -d -r t03 -n 40 -p 50000
       -e /tmp/xtrep_log -g /usr/home/user01/lck TORA01

Contents of /usr/home/user01/lck

IN EXCLUSIVE MODE NOWAIT

(d) Example 4

Output table TORA01 at HOST1 to a file at HOST3. Specify the following options:

Create a DAT-format file.
The name of the output file is /usr/home/user01/data/TORA01.
Do not specify a data type to be converted for any column.

Command specification

xtrepO -R dat -o TORA01 -h HOST3 -s /usr/home/user01/clm TORA01

Contents of /usr/home/user01/clm

C01,C02,C03

(e) Example 5