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

The following are defaults and examples:

— Date values

◦ Default: %C%y-%m-%d

◦ Example: The input characters “2007–10–05” can be processed without a format

definition and is interpreted as October 5, 2007.

— Time values

◦ Default: %H:%M:%s

◦ Example: The input characters “13:32:00” can be processed without a format

definition and is interpreted as 1:32 p.m.

— Timestamp values

◦ Default: %C%y-%m-%d %H:%M:%S

◦ Example: The input characters “2007–10–05 13:32:00.000000” can be processed

without a format definition and is interpreted as 1:32 p.m. on October 5, 2007.

Control File Organization and Syntax 33

1 2 ... 28 29 30 31 32 33 34 35 36 37 38 ... 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

Commentaires sur ces manuels

Pas de commentaire

Hp Neoview Release 2.4 Software Manuel d'utilisateur Page 33

Commentaires sur ces manuels

Produits connexes et manuels pour Logiciel Hp Neoview Release 2.4 Software