Hp Neoview Release 2.3 Software Manuale Utente Scaricare il pdf (Pagina 100)

Error Message and Behavior

The control file generator can encounter connection, SQL, and file I/O type errors. If a connection

or a file I/O error is generated, the files may not be written. If a table is “skipped”, it is due to an

SQL error only.

Packaging

The control file generator is packaged as part of the Transporter package. It is located in the

Transporter client directory structure in $NVTHOME/utils.

100 Control File Editor and Control File Generator

1 2 ... 95 96 97 98 99 100 101 102 103 104 105 ... 109 110

HP Part Number: 545787-001 1
Published: April 2008 1
Edition: Release 2.3 1
Table of Contents 3
4 Table of Contents 4
Table of Contents 5 5
6 Table of Contents 6
List of Tables 7
List of Examples 9
About This Document 11
HP Encourages Your Comments 12
General Syntax Notation 12
General Syntax Notation 13 13
Publishing History 14
1 Overview 15
Client Components 16
Installation Requirements 17
Installing Transporter 17
Installing Transporter 19 19
3 Functions and Features 21
22 Functions and Features 22
4 Security 23
Creating a Control File 25
Control File Limits 25
Typeformats 29
Dataformats 32
FROM myTable 35
FROM T1, T2 35
WHERE T1.A = T2.A 35
INFO = NULL 38
EMP_ID = identity loader 39
FIRSTNAME = FIRST_NAME 39
Comments 44
Supported Data Types 45
6 Control File Options 47
48 Control File Options 48
50 Control File Options 50
52 Control File Options 52
54 Control File Options 54
7 Load and Extract Operations 57
Stopping the Client 58
The Transporter Job 58
Sources and Targets 59
Parallel Streams 59
Requirements 61
8 Data Processing 63
Delimited Data 64
Interpreted as ...Input Data 65
New York, NY“New York, NY” 65
Not “quoted”Not “quoted” 65
Delimited Data 65 65
66 Data Processing 66
9 Troubleshooting 67
68 Troubleshooting 68
Control File Metadata Tables 69
70 Troubleshooting 70
A Control File Examples 73
78 Control File Examples 78
84 Control File Examples 84
86 Control File Examples 86
88 Control File Examples 88
90 Control File Examples 90
92 Control File Examples 92
94 Control File Examples 94
96 Control File Examples 96
Control File Editor 97
Control File Generator 99
Error Message and Behavior 100
Packaging 100
C Global Options Table 101
D Reserved Keywords 103
108 Index 108

Commenti su questo manuale

Nessun commento

Hp Neoview Release 2.3 Software Manuale Utente Pagina 100

Commenti su questo manuale

Prodotti e manuali riguardandi Software Hp Neoview Release 2.3 Software