beautypg.com

6 control file options, 7 load and extract operations – HP Neoview Release 2.3 Software User Manual

Page 4

background image

Options............................................................................................................................................28
Typeformats.....................................................................................................................................29
Dataformats.....................................................................................................................................32
Maps................................................................................................................................................36
Sources.............................................................................................................................................40
Jobs...................................................................................................................................................42
Comments........................................................................................................................................44
Include.............................................................................................................................................45

Supported Data Types..........................................................................................................................45

6 Control File Options.....................................................................................................47

baddatafile............................................................................................................................................47
commitsize............................................................................................................................................47
crossoveryear........................................................................................................................................47
datasource.............................................................................................................................................47
deleteonerror.........................................................................................................................................48
discards.................................................................................................................................................48
enabletriggers........................................................................................................................................48
endseq...................................................................................................................................................48
errors.....................................................................................................................................................49
faileddatafile.........................................................................................................................................49
forcestaging...........................................................................................................................................49
multipart...............................................................................................................................................50
noaudit..................................................................................................................................................51
nullstring...............................................................................................................................................51
operation...............................................................................................................................................52
parallel..................................................................................................................................................52
parallelstreams......................................................................................................................................52
password...............................................................................................................................................52
retries.....................................................................................................................................................53
rowsetsize..............................................................................................................................................53
sorted.....................................................................................................................................................53
startseq..................................................................................................................................................53
system...................................................................................................................................................54
tenacity..................................................................................................................................................54
timeout..................................................................................................................................................54
truncate.................................................................................................................................................54
url..........................................................................................................................................................54
user........................................................................................................................................................55

7 Load and Extract Operations ....................................................................................57

Steps for Performing Load and Extract Operations.............................................................................57
Starting the Transporter Client ............................................................................................................57

Starting the Client on Linux Systems..............................................................................................58
Starting the Client on Windows Systems........................................................................................58

Stopping the Client...............................................................................................................................58
The Transporter Job...............................................................................................................................58
Sources and Targets..............................................................................................................................59
Parallel Streams.....................................................................................................................................59

Parallel Streams for Load Jobs.........................................................................................................59
Parallel Streams for Extract Jobs......................................................................................................59

Transaction Modes for Load Jobs.........................................................................................................60
Loading Data With JMS Trickle Feed....................................................................................................60

4

Table of Contents