Hp Neoview Release 2.4 Software Manual de usuario descargar pdf (Pagina 92)

PHONE = PHONE,

SSN = SSN,

INFO1 = INFO1,

INFO2 = INFO2

)

map2 from dataformat2 to dataformat3

(

FIRST_NAME = FIRST_NAME,

LAST_NAME = LAST_NAME,

ADDRESS = ADDRESS,

ZIP = ZIP,

PHONE = PHONE,

SSN = SSN,

INFO1 = INFO1,

INFO2 = INFO2

)

}

# comment: define 2 separate jobs - one for load, one for extract

# comment: note that load or extract is a job attribute, and cannot be combined into a single job

jobs

{

load1 load options ( parallel = "false" )

(

source src1 target tgt1 map map1

)

extract1 extract options ( parallel = "true" )

(

source src2 target tgt2 map map2

)

}

92 Control File Examples

1 2 ... 87 88 89 90 91 92 93 94 95 96 97 ... 123 124

HP Part Number: 514030-001 1
Published: April 2009 1
Edition: Release 2.4 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 8
About This Document 9
Neoview Customer Library 10
HP Encourages Your Comments 11
General Syntax Notation 11
Publishing History 13
1 Overview 15
Client Components 16
Installation Requirements 17
Installing Transporter 17
The Transporter API 20
3 Functions and Features 21
22 Functions and Features 22
4 Security 23
Creating a Control File 25
Control File Limits 25
Typeformats 29
— backslash (\\) 32
“%D:%H:%M:%D” 34
“%H:%M:%D:%S” 34
Dataformats 35
FROM myTable 38
FROM T1, T2 38
WHERE T1.A = T2.A 38
INFO = NULL 41
Comments 47
Supported Data Types 48
6 Control File Options 49
50 Control File Options 50
Encoding For A Load Job 52
Encoding For An Extract Job 52
54 Control File Options 54
56 Control File Options 56
58 Control File Options 58
60 Control File Options 60
7 Load and Extract Operations 61
Stopping the Client 62
The Transporter Job 63
Sources and Targets 63
Parallel Streams 63
Requirements 65
8 Data Processing 69
Delimited Data 70
Interpreted as ...Input Data 71
New York, NY“New York, NY” 71
Not “quoted”Not “quoted” 71
Delimited Data 71 71
72 Data Processing 72
9 Troubleshooting 73
Job Recovery 74
Control File Metadata Tables 76
A Control File Examples 79
84 Control File Examples 84
90 Control File Examples 90
92 Control File Examples 92
94 Control File Examples 94
96 Control File Examples 96
98 Control File Examples 98
100 Control File Examples 100
102 Control File Examples 102
104 Control File Examples 104
Control File Editor 107
Setting the Default Folder 108
Validating a Control File 108
Control File Generator 109
Optional Arguments 110
Error Message and Behavior 111
Packaging 111
C Global Options Table 113
XX“url” (page 60) 114
XX“user” (page 60) 114
114 Global Options Table 114
D Reserved Keywords 115
E Transporter Exit Codes 117
Glossary 119
122 Index 122

Comentarios a estos manuales

Sin comentarios

Hp Neoview Release 2.4 Software Manual de usuario Pagina 92

Comentarios a estos manuales

Relacionado con productos y manuales para Software Hp Neoview Release 2.4 Software