Neoview Transporter User Guide (R2.5)

List of Examples
5-1 Supported Scalar Expressions ......................................................................................................44
9-1 Examples of Custom Log File Locations.......................................................................................80
9-2 Sample HP_TRANSPORTER_BASE_JOB_STATS File..................................................................81
9-3 Sample HP_TRANSPORTER_CONTROL_FILES File..................................................................82
9-4 Sample HP_TRANSPORTER_CONTROL_FILE_TEXT File.........................................................82
9-5 Identify All Job Entries that Successfully Completed Within the Last Seven Days......................83
9-6 Identify All Job Entries That Were Started in the Last 24 Hours But Have Not Completed —
Either Failed or In Progress...........................................................................................................83
9-7 Identify All Jobs Executed From Host abc Using the Latest Version of Control File /home/
control files/ControlFile.txt.......................................................................................84
9-8 Delete All Job Statistics For Jobs Started Three Or More Months Ago.........................................84
9-9 Delete All Versions of Control File /home/control files/ControlFile.txt That Have
Been Used On Host abc................................................................................................................84
A-1 Control File: Datatypes..................................................................................................................86
A-2 Control File: Extract From Neoview SQL Source..........................................................................89
A-3 Control File: Extract From Table Source to Named Pipe..............................................................91
A-4 Control File: Load Fixed Width Data............................................................................................93
A-5 Control File: Include Defining Dataformats .................................................................................95
A-6 Control File: Include — Load From File to Table..........................................................................96
A-7 Control File: Load and Extract......................................................................................................97
A-8 Control File: Multiple Dataformats and Maps..............................................................................99
A-9 Control File: Reflexive Update....................................................................................................101
A-10 Control File: Update with Constant, NULL, or Expression .......................................................102
A-11 Control File: Identity column......................................................................................................104
A-12 Control File: Usage of NULLSTRING.........................................................................................105
A-13 Control File: NOAUDIT mode....................................................................................................106
A-14 Control File: Forcestaging Load with Multiple Job Entries in a Single Job.................................107
A-15 Control File: Load From File to Table Using Subset of Source Columns....................................109
A-16 Control File: Load File to Table Without 1 to 1 Mapping............................................................111
A-17 Control File: Simple Virtual Partitioned Load.............................................................................113
B-1 EIL: Specifying the inlinesort Control File Option......................................................................116
B-2 EIL: Specifying the loadid Control File Option...........................................................................116
B-3 EIL: Specifying an Exception Table.............................................................................................116
B-4 Enhanced Initial Load Sample Control File................................................................................117
8 List of Examples