Neoview Database Administrator's Guide (R2.2)
11 132874 132874 1195 131679
12 132850 132850 1196 131654
13 132755 132755 1158 131597
14 132748 132748 1145 131603
15 132580 132580 1219 131361
16 132972 132972 1167 131805
17 132393 132393 1228 131165
18 133074 133074 1199 131875
19 132348 132348 1193 131155
20 133315 133315 1167 132148
21 133236 133236 1152 132084
22 133555 133555 1221 132334
23 133244 133244 1196 132048
24 133081 133081 1189 131892
25 132706 132706 1181 131525
26 133354 133354 1292 132062
27 133274 133274 1211 132063
28 132564 132564 1144 131420
29 133692 133692 1185 132507
30 132279 132279 1212 131067
31 133361 133361 1222 132139
Tot. 4258000 4258000 38374 4219626
CTot. 4995000 4995000 45000 4950000
----------------------------------------------------------------
[12:19:07] MASTER> MASTER Execution completed with warnings. Bad records rejected on target.
Extracting Data
You can also use the Neoview Loader to configure extract tasks that extract data from
hash-partitioned tables and store the extracted data in flat files or named pipes on the Linux
Loader platform. You can store the extracted data in fixed-width or delimited formats.
Specify the data to by extracted with a SELECT statement as part of the task configuration request.
The SELECT statement can reference tables, views, and synonyms and can include JOINs. The
SELECT statement specifies the columns to be extracted, and the order of the columns in the
SELECT statement determines the sequence of the output data.
The query is validated when the task is configured. All tables, views and synonyms referenced
in the query must exist when the task is configured. If a synonym is used, it will be retained in
the task definition and will not be fully resolved until the query is executed.
Step 1: Configure an Extract Task
To define an extract task, enter a gcmd command on the Linux platform with requestType
CONFIG_TASK_EXTRACT:
gcmd -rt CONFIG_TASK_EXTRACT argument-list
See “Command-Line Arguments for Extract Tasks” (page 127) for descriptions of each command
argument.
Examples
• This task configuration extracts data in parallel from the table NEO.DB.T1 and writes the
data in comma delimited format to five output files, whose prefix is
/home/roledba/data/extract-OCT01:
gcmd -rt CONFIG_TASK_EXTRACT -tk DAILY-EXTRACT \
-ss neo0001 -sn NEO-CMSERVER \
-ii “SELECT col1, col2, col3 FROM NEO.DB.T1 BROWSE ACCESS”\
-pt NEO.DB.T1 -ot FILE -oi /home/roledba/data/extract-OCT01 \
-nf 5 -fd , -of n -un role.dba -pw roledba
It writes the output to these files:
Extracting Data 121