beautypg.com

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

Page 4

background image

5 Control File Organization and Syntax.......................................................................25

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

Version.............................................................................................................................................27
Options............................................................................................................................................28
Typeformats.....................................................................................................................................29
Dataformats.....................................................................................................................................35
Maps................................................................................................................................................39
Sources.............................................................................................................................................43
Jobs...................................................................................................................................................46
Comments........................................................................................................................................47
Include.............................................................................................................................................48

Supported Data Types..........................................................................................................................48

6 Control File Options.....................................................................................................49

autotran.................................................................................................................................................49
baddatafile............................................................................................................................................49
commitsize............................................................................................................................................49
crossoveryear........................................................................................................................................49
datasource.............................................................................................................................................50
deleteonerror.........................................................................................................................................50
discards.................................................................................................................................................50
enabletriggers........................................................................................................................................51
encoding................................................................................................................................................51

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

endseq...................................................................................................................................................53
errors.....................................................................................................................................................53
faileddatafile.........................................................................................................................................54
forcestaging...........................................................................................................................................54
multipart...............................................................................................................................................55
noaudit..................................................................................................................................................56
nullstring...............................................................................................................................................56
operation...............................................................................................................................................57
parallel..................................................................................................................................................57
parallelstreams......................................................................................................................................57
password...............................................................................................................................................57
retries.....................................................................................................................................................58
rowsetsize..............................................................................................................................................58
sorted.....................................................................................................................................................58
startseq..................................................................................................................................................58
system...................................................................................................................................................59
taskrowsetsize.......................................................................................................................................59
teamsize.................................................................................................................................................59
tenacity..................................................................................................................................................59
timeout..................................................................................................................................................59
truncate.................................................................................................................................................60
url..........................................................................................................................................................60
user........................................................................................................................................................60

4

Table of Contents