Neoview Database Administrator's Guide (R2.2)

Command-Line Arguments for Extract Tasks
Required Arguments for Configuring an Extract Task
Required arguments for an extract task are described in Table 8-6:
Table 8-6 Required CONFIG_TASK_EXTRACT Arguments
DescriptionDefault
Value
Long
Name
Short
Name
The text of the SELECT query to be used to extract the data.
The total length of the query must be less than 32K. It must be
inclosed within double quotes. For example:
“SELECT * FROM TABLE1”
If the query includes delimited names, the double quotes
surrounding the delimited name must be preceded by a
backslash character. For example:
-ii “SELECT \”COLUMN\” FROM T”
N.A.
inputItem-ii
If the query includes a view without a join, and a partitioning
table has been specified, the column select-list cannot include
any column names and can only be “*”. For example, this
statement is valid:
-ii “SELECT * FROM V1, T1 WHERE T1.COLA = ‘ABC’
”
This statement is invalid if a partitioning table has been defined
for the table:
-ii “SELECT C1 FROM V1 “
The directory name for the output file or pipe, with the file or
pipe name prefix. The Extractor will append a stream number,
starting from 1, to the file name for each output file or pipe, up
to the number of output files or pipes specified for the task. If
you specify the concatenate argument the output file name will
be the file or pipe name appended with “.out”. For example:
/data/ext/daily
N.A.
outputItem-oi
If you requested two output files, these files are created:
/data/ext/daily-1
and
/data/ext/daily-2
.
Neoview password. For example:
User9999
N.A.
password-pw
Start task request. Must be set to
CONFIG_TASK_EXTRACT
N.A.
requestType-rt
Name of the target data server on the Neoview platform server;
maximum 32 characters. Normally, this is set to
NEO-CMSERVER
.
N.A.
sourceServerName-sn
Name of the data source system; which is the name of your
Neoview server; maximum 32 characters. For example:
atnsk03
N.A.
sourceSystemName-ss
Command-Line Arguments for Extract Tasks 127