Hp Neoview Release 2.4 Software Manual de usuario Pagina 91
- Pagina / 124
- Tabla de contenidos
- SOLUCIÓN DE PROBLEMAS
- MARCADORES
Valorado. / 5. Basado en revisión del cliente
Example A-7 Control File: Load and Extract
/* Simple Load From File To Table & Extract From Neoview SQL Source To File */
version 1.0;
options
{
errors = 1000,
discards = 100,
rowsetsize = 5000,
}
dataformats
{
dataformat1 delimited
records separated by <nl>
fields delimited by <,>
optionally qualified by <">
(
FIRST_NAME char,
LAST_NAME char,
ADDRESS char,
ZIP int,
PHONE char,
SSN largeint,
INFO1 char,
INFO2 char
)
dataformat2 sql fields
(
FIRST_NAME char,
LAST_NAME char,
ADDRESS char,
ZIP int,
PHONE char,
SSN largeint,
INFO1 char,
INFO2 char
)
dataformat3 delimited
records separated by <nl>
fields delimited by <,>
optionally qualified by <">
(
(
SSN largeint,
FIRST_NAME char,
LAST_NAME char,
ADDRESS char,
ZIP int,
PHONE char,
INFO1 char,
INFO2 char
)
}
sources {
src1 file "./data_files/sn_nvt.dat"
tgt1 jdbc table NEO.nvt.sn_nvt options
(
system = "asl0101",
user = "user",
password = "transport",
datasource = "Admin_Load_DataSource",
url = "jdbc:hpt4jdbc://txnaslan01.txn.cpqcorp.net:18650/"
)
src2 jdbc sql "select * from NEO.nvt.sn_nvt_ext order by SSN" options
(
system = "asl0101",
user = "user",
password = "transport",
datasource = "Admin_Load_DataSource",
url = "jdbc:hpt4jdbc://txnaslan01.txn.cpqcorp.net:18650/"
)
tgt2 file "./data_files/sn_ext.dat"
}
maps {
map1 from dataformat1 to dataformat2
(
FIRST_NAME = FIRST_NAME,
LAST_NAME = LAST_NAME,
ADDRESS = ADDRESS,
ZIP = ZIP,
91
- 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
Relacionado con productos y manuales para Software Hp Neoview Release 2.4 Software
Software Hp OneView for VMware vCenter Manual de usuario
(113 paginas)
(113 paginas)
Software Hp ПО HP Insight Online Manual de usuario
(58 paginas)
(58 paginas)
Software Hp ПО v1 HP SkyRoom Manual de usuario
(70 paginas)
(70 paginas)
Software Hp Smart Update Manager Manual de usuario
(102 paginas)
(102 paginas)
Software Hp Smart Update Manager Manual de usuario
(134 paginas)
(134 paginas)
Software Hp Smart Update Manager Manual de usuario
(146 paginas)
(146 paginas)
(259 paginas)
(159 paginas)© 2020, manymanuals.es. Todos los derechos reservados | 0.043 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Comentarios a estos manuales