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

Example A-6 Control File: Include — Load From File to Table

/* Simple Load From File To Table Using INCLUDE To Include Control File Fragment (File 1/2) */

version 1.0;

# comment: control file fragment include_part_2.cf defines the data formats

%include "./CF/include_part_2.cf"

options

{

errors = 1000,

discards = 100,

rowsetsize = 5000

}

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/"

)

}

maps {

map1 from dataformat1 to dataformat2

(

FIRST_NAME = FIRST_NAME,

LAST_NAME = LAST_NAME,

ADDRESS = ADDRESS,

ZIP = ZIP,

PHONE = PHONE,

SSN = SSN,

INFO1 = INFO1,

INFO2 = INFO2

)

}

jobs

{

load1 load options ( parallel = "false" )

(

source src1 target tgt1 map map1

)

}

84 Control File Examples

1 2 ... 79 80 81 82 83 84 85 86 87 88 89 ... 109 110

Commentaires sur ces manuels

Pas de commentaire

Hp Neoview Release 2.3 Software Manuel d'utilisateur Page 84

Commentaires sur ces manuels

Produits connexes et manuels pour Logiciel Hp Neoview Release 2.3 Software