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

Example A-11 Control File: Identity column

This example of defines an IDENTITY column. CUSTOMER_NUMBER can be any numeric data

type (SMALLINT, INTEGER, LARGEINT) column.

/*--------------------------------*/

/* IDENTITY column */

/*--------------------------------*/

mapexpr from dataformat1 to dataformat2

(

PHONE = PHONE,

SSN = SSN,

FIRST_NAME = FIRST_NAME,

LAST_NAME = LAST_NAME,

ADDRESS = ADDRESS,

ZIP = ZIP,

CUSTOMER_NUMBER = identity loader,

INFO1 = INFO1,

INFO2 = INFO2,

DATE_ENTERED = expression ("current_date")

)

92 Control File Examples

1 2 ... 87 88 89 90 91 92 93 94 95 96 97 ... 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 92

Commenti su questo manuale

Prodotti e manuali riguardandi Software Hp Neoview Release 2.3 Software