Neoview Database Administrator's Guide (R2.2)

Configuring a Data-Task To Load a Table With An Identity Column
If the table you are loading contains an identity column, the Neoview Loader checks the value
of the -ic (identityColumn) option. Specify USER or SYSTEM (the default is SYSTEM, so you
need to set this option only if the default was changed or the option is to be set to USER).
For example:
gcmd -rt CONFIG_TASK_LOAD \
-tk TASK_1 -rf Y \
-ic SYSTEM \
-gs server1 -tn NEO-CMSERVER \
-it FILE \
-ii /opt/testdata/WISC-INSERT \
-ot TABLE -oi CAT.SCH.WISC \
-un user1 -pw mypassword \
-of N
Java Message System (JMS) Input
For details about JMS input, see Appendix B (page 143).
Using Named Pipes
If you configure a load task to use one or more named pipes, the Neoview Loader will attempt
to open the named pipe (or pipes.) If the pipe does not exist, the Loader creates it. At the
conclusion of the load task, the Loader deletes the named pipe (or pipes).
Command-Line Arguments for Load Tasks
gcmd converts command-line arguments into XML and sends them to a data-load server.
To run gcmd, use the format:
gcmd argument-list
Each argument is preceded by a hyphen (-). You can specify the short form or the long form of
the argument name. For example, you can specify -rt or -requestType.
Required Arguments for Configuring a Data-Load Task
Table 8-1 Required CONFIG_TASK_LOAD Arguments
DescriptionDefault
Value
Long
Name
Short
Name
Name of the target system, which is the name of your Neoview
server; maximum 32 characters. For example:
atnsk03
N.A.
targetSystemName-gs
Name of the data file to be used for input; maximum 1024
characters. For example:
/home/user1/test/data/data01
N.A.
inputItem-ii
Output item; maximum 1024 characters. For example:
CAT.SCH.T1
N.A.
outputItem-oi
Neoview password; minimum 8 characters, maximum 32
characters. For example:
User9999
You can set environmental variables for the password. See
“User Name and Password” (page 115).
N.A.
password-pw
108 Using the Neoview Loader