Hp Neoview Release 2.4 Software Manual de usuario descargar pdf (Pagina 87)

Example A-4 Control File: Load Fixed Width Data

/* Load Fixed Width Data */

version 1;

options

{

errors = 1000,

discards = 100,

rowsetsize = 5000

}

dataformats

{

# fixed width data source file

dataformat1 fixed

record length 443

fields positions

(

13,

37,

165,

169,

179,

187,

315

)

(

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 file "./data_files/sn_nvt_fw.dat"

tgt1 jdbc table NEO.nvt.sn_nvt options

(

system = "asl0101",

user = "user",

password = "transport",

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

datasource = "Admin_Load_DataSource"

)

}

maps {

map1 from dataformat1 to dataformat2

(

FIRST_NAME = FIRST_NAME,

1 2 ... 82 83 84 85 86 87 88 89 90 91 92 ... 123 124

Comentarios a estos manuales

Sin comentarios

Hp Neoview Release 2.4 Software Manual de usuario Pagina 87

Comentarios a estos manuales

Relacionado con productos y manuales para Software Hp Neoview Release 2.4 Software