beautypg.com
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 HaveBeen 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