Hp Neoview Release 2.3 Software Manuel d'utilisateur télécharger pdf (Page 81)

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 ... 76 77 78 79 80 81 82 83 84 85 86 ... 109 110

Commentaires sur ces manuels

Pas de commentaire

Hp Neoview Release 2.3 Software Manuel d'utilisateur Page 81

Commentaires sur ces manuels

Produits connexes et manuels pour Logiciel Hp Neoview Release 2.3 Software