
List of Examples
5-1 Supported Scalar Expressions ......................................................................................................42
9-1 Examples of Custom Log File Locations.......................................................................................74
9-2 Sample HP_TRANSPORTER_BASE_JOB_STATS File..................................................................75
9-3 Sample HP_TRANSPORTER_CONTROL_FILES File..................................................................76
9-4 Sample HP_TRANSPORTER_CONTROL_FILE_TEXT File.........................................................76
9-5 Identify All Job Entries that Successfully Completed Within the Last Seven Days......................77
9-6 Identify All Job Entries That Were Started in the Last 24 Hours But Have Not Completed —
Either Failed or In Progress...........................................................................................................77
9-7 Identify All Jobs Executed From Host abc Using the Latest Version of Control File /home/
control files/ControlFile.txt.......................................................................................78
9-8 Delete All Job Statistics For Jobs Started Three Or More Months Ago.........................................78
9-9 Delete All Versions of Control File /home/control files/ControlFile.txt That Have
Been Used On Host abc................................................................................................................78
A-1 Control File: Datatypes..................................................................................................................80
A-2 Control File: Extract From Neoview SQL Source..........................................................................83
A-3 Control File: Extract From Table Source to Named Pipe..............................................................85
A-4 Control File: Load Fixed Width Data............................................................................................87
A-5 Control File: Include Defining Dataformats .................................................................................89
A-6 Control File: Include — Load From File to Table..........................................................................90
A-7 Control File: Load and Extract......................................................................................................91
A-8 Control File: Multiple Dataformats and Maps..............................................................................93
A-9 Control File: Reflexive Update......................................................................................................95
A-10 Control File: Update with Constant, NULL, or Expression .........................................................96
A-11 Control File: Identity column........................................................................................................98
A-12 Control File: Usage of NULLSTRING...........................................................................................99
A-13 Control File: NOAUDIT mode....................................................................................................100
A-14 Control File: Forcestaging Load with Multiple Job Entries in a Single Job.................................101
A-15 Control File: Load From File to Table Using Subset of Source Columns....................................103
A-16 Control File: Load File to Table Without 1 to 1 Mapping............................................................105
8 List of Examples
Comentarios a estos manuales