Hp Neoview Release 2.3 Software Manuel d'utilisateur Page 48
- Page / 110
- Table des matières
- DEPANNAGE
- MARQUE LIVRES
Noté. / 5. Basé sur avis des utilisateurs
Specifies the data source name for ODBC and JDBC connections to the Neoview system.
datasource_name must be a server-side data source defined on the Neoview system.
Example:
datasource = "LOAD01"
Specifies a data source named LOAD01.
deleteonerror
deleteonerror = "true" | "false"
The default is “false”.
For an extract operation: when this option is set to “false”, Transporter does not delete target
files or intermediate files when the operation terminates due to an error.
For an extract operation: when this option is set to “true”, Transporter deletes target files and
intermediate files when the operation terminates due to an error.
See the description of the “multipart” (page 50) option for more detail on intermediate files
created by Transporter.
This option is ignored for load operations.
For extract operations where the target is a named pipe, this option applies only to intermediate
files. Transporter never attempts to delete target pipes.
discards
discards = number
The default value is 1000.
• For a job where the “parallel” (page 52) option is “true”:
When the number of records written to the baddatafile file for the job reaches number,
Transporter stops processing the job.
• For a job where the “parallel” (page 52) option is “false”:
When the number of records written to the baddatafile file for a job entry reaches number,
Transporter stops processing the job entry.
If number is zero, this option is disabled. Transporter does not stop processing a job or job entry
based on the number of discarded records.
Example:
discard = 2000
Tells Transporter to stop the job after 2000 discards.
enabletriggers
enabletriggers = "true" | "false"
The default is “false”.
If you want to enable triggers on a table during load jobs, set this option to “true”.
If you want to disable triggers on a table during load jobs, set this option to “false”.
This option is ignored for extract operations.
endseq
endseq = "sequence of characters"
endseq, along with the “startseq” (page 53) option, are specific to named pipe sources and allow
specification of start and end sequence records.
48 Control File Options
- 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
Produits connexes et manuels pour Logiciel Hp Neoview Release 2.3 Software
(99 pages)
(37 pages)
(120 pages)© 2020, manymanuals.fr. Tous droits réservés | 0.034 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Commentaires sur ces manuels