beautypg.com

Jobs – HP Neoview Release 2.4 Software User Manual

Page 46

background image

Jobs

The jobs section specifies a list of Transporter jobs. A job is a collection of job entries. Jobs are
processed serially, one at a time. This section starts with the keyword jobs followed by a list of
job definitions surrounded by curly braces.

The Java client accepts control files containing multiple jobs.

jobs
{

job-definition [{job-definition ] ...

}

job-definition:
jobname { load | extract }[options job-options]
{ job-entry-list }

job-options:
(

option_name = option_value [, option_name = option_value

)

job-entry-list:

job-entry [, job-entry ]...

job-entry:

source sourcename target { targetname | ( targetname-list )}

map mapname [ options job-entry-options ]

targetname-list:

targetname [, targetname ]...

job-entry-options
(
option_name = option_value [, option_name = option_value ] ...
)

job-definition

one or more occurrences of job-definition, separated by a comma (,). The last
job-definition

should not use the comma separator.

jobname

The name you choose for this job. jobname must be unique within the jobs namespace.
jobname

is case-insensitive and cannot exceed 64 bytes.

load | extract

“load” or “extract” means this job is a load job or an extract job, respectively. A load job
is used to load data into SQL tables, while an extract job is used to extract data from SQL
tables.

options

one or more occurrences of job-options, separated by a comma (,). The last job-options
should not use the comma separator.

The options you define at the job level override global options defined in the options section.
The following job options are supported:

“baddatafile” (page 49)

“commitsize” (page 49)

“deleteonerror” (page 50)

“discards” (page 50)

“errors” (page 53)

“faileddatafile” (page 54)

46

Control File Organization and Syntax