
List of Examples
9-1 Sample HP_TRANSPORTER_BASE_JOB_STATS File..................................................................68
9-2 Sample HP_TRANSPORTER_CONTROL_FILES File..................................................................69
9-3 Sample HP_TRANSPORTER_CONTROL_FILE_TEXT File.........................................................69
9-4 Identify All Job Entries that Successfully Completed Within the Last Seven Days......................70
9-5 Identify All Job Entries That Were Started in the Last 24 Hours But Have Not Completed —
Either Failed or In Progress...........................................................................................................70
9-6 Identify All Jobs Executed From Host abc Using the Latest Version of Control File
/home/control files/ControlFile.txt..........................................................................71
9-7 Delete All Job Statistics For Jobs Started Three Or More Months Ago.........................................71
9-8 Delete All Versions of Control File /home/control files/ControlFile.txt That Have
Been Used On Host abc................................................................................................................71
A-1 Control File: Datatypes..................................................................................................................74
A-2 Control File: Extract From Neoview SQL Source..........................................................................77
A-3 Control File: Extract From Table Source to Named Pipe..............................................................79
A-4 Control File: Load Fixed Width Data............................................................................................81
A-5 Control File: Include Defining Dataformats .................................................................................83
A-6 Control File: Include — Load From File to Table..........................................................................84
A-7 Control File: Load and Extract......................................................................................................85
A-8 Control File: Multiple Dataformats and Maps..............................................................................87
A-9 Control File: Reflexive Update......................................................................................................89
A-10 Control File: Update with Constant, NULL, or Expression .........................................................90
A-11 Control File: Identity column........................................................................................................92
A-12 Control File: Usage of NULLSTRING...........................................................................................93
A-13 Control File: NOAUDIT mode......................................................................................................94
A-14 Control File: Forcestaging Load with Multiple Job Entries in a Single Job..................................95
9
Commentaires sur ces manuels