beautypg.com

5 control file organization and syntax, 6 control file options – HP Neoview Release 2.5 Software User Manual

Page 4

background image

5 Control File Organization and Syntax.......................................................................27

Creating a Control File..........................................................................................................................27
Control File Limits................................................................................................................................27
Control File Organization and Syntax..................................................................................................27

Version.............................................................................................................................................29
Options............................................................................................................................................30
Typeformats.....................................................................................................................................31
Dataformats.....................................................................................................................................37
Maps................................................................................................................................................41
Sources.............................................................................................................................................45
Jobs...................................................................................................................................................48
Comments........................................................................................................................................50
Include.............................................................................................................................................50

Supported Data Types..........................................................................................................................51

6 Control File Options.....................................................................................................53

autotran.................................................................................................................................................53
baddatafile............................................................................................................................................53
commitsize............................................................................................................................................53
compression..........................................................................................................................................53
crossoveryear........................................................................................................................................54
datasource.............................................................................................................................................54
deleteonerror.........................................................................................................................................54
discards.................................................................................................................................................54
enabletriggers........................................................................................................................................55
encoding................................................................................................................................................55

Encoding For A Load Job................................................................................................................56
Encoding For An Extract Job...........................................................................................................56
Changing Default Encoding Behavior Using Transporter Properties.............................................56

endpart..................................................................................................................................................57
endseq...................................................................................................................................................57
errors.....................................................................................................................................................58
exceptiontable.......................................................................................................................................58
faileddatafile.........................................................................................................................................58
forcestaging...........................................................................................................................................59
inlinesort...............................................................................................................................................59
loadid....................................................................................................................................................59
multipart...............................................................................................................................................60
noaudit..................................................................................................................................................61
nullstring...............................................................................................................................................61
operation...............................................................................................................................................62
parallel..................................................................................................................................................62
parallelstreams......................................................................................................................................62
password...............................................................................................................................................63
retries.....................................................................................................................................................63
rowsetsize..............................................................................................................................................63
sorted.....................................................................................................................................................63
startpart.................................................................................................................................................64
startseq..................................................................................................................................................64
system...................................................................................................................................................64
taskrowsetsize.......................................................................................................................................64
teamsize.................................................................................................................................................65
tenacity..................................................................................................................................................65
timeout..................................................................................................................................................65

4

Table of Contents