Hp Neoview Release 2.3 Software Manuel d'utilisateur télécharger pdf (Page 86)

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

)

}

86 Control File Examples

1 2 ... 81 82 83 84 85 86 87 88 89 90 91 ... 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

Commentaires sur ces manuels

Pas de commentaire

Hp Neoview Release 2.3 Software Manuel d'utilisateur Page 86

Commentaires sur ces manuels

Produits connexes et manuels pour Logiciel Hp Neoview Release 2.3 Software