Hp Neoview Release 2.4 Software Bedienungsanleitung PDF herunterladen (Seite 85)

Example A-3 Control File: Extract From Table Source to Named Pipe

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

/* Simple Extract From Table Source To Named Pipe */

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

version 1;

options

{

errors = 1000,

rowsetsize = 5000,

discards = 100

}

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

)

}

sources {

src1 jdbc table NEO.nvt.sn_nvt_ext options

(

system = "asl0101",

user = "user",

password = "transport",

datasource = "Admin_Load_DataSource",

url = "jdbc:hpt4jdbc://txnaslan01.txn.cpqcorp.net:18650/"

)

tgt1 pipe "./data_files/sn_nvtpipe"

}

maps {

map1 from dataformat2 to dataformat1

(

FIRST_NAME = FIRST_NAME,

LAST_NAME = LAST_NAME,

ADDRESS = ADDRESS,

ZIP = ZIP,

PHONE = PHONE,

SSN = SSN,

INFO1 = INFO1,

INFO2 = INFO2

)

}

jobs

1 2 ... 80 81 82 83 84 85 86 87 88 89 90 ... 123 124

Kommentare zu diesen Handbüchern

Keine Kommentare

Hp Neoview Release 2.4 Software Bedienungsanleitung Seite 85

Kommentare zu diesen Handbüchern

Verwandte Produkte und Handbücher für Software Hp Neoview Release 2.4 Software