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

Example A-2 Control File: Extract From Neoview SQL Source

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

/* Simple Extract From Neoview SQL Source To File */

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

version 1.0;

options

{

errors = 100,

discards = 100,

rowsetsize = 1000

}

dataformats

{

dataformat1 delimited

records separated by <nl>

fields delimited by <,>

optionally qualified by <">

(

SSN largeint,

FIRST_NAME char,

LAST_NAME char,

ADDRESS char,

ZIP int,

PHONE char,

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 sql "select * from NEO.nvt.sn_nvt_ext order by SSN" options

(

system = "asl0101",

user = "user",

password = "transport",

datasource = "Admin_Load_DataSource",

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

)

tgt1 file "./data_files/sn_ext.dat"

}

maps {

map1 from dataformat2 to dataformat1

(

SSN = SSN,

FIRST_NAME = FIRST_NAME,

1 2 ... 78 79 80 81 82 83 84 85 86 87 88 ... 123 124

Comentarios a estos manuales

Sin comentarios

Hp Neoview Release 2.4 Software Manual de usuario Pagina 83

Comentarios a estos manuales

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