beautypg.com

HP Neoview Release 2.5 Software User Manual

Page 134

background image

character, 51
date/time, 51
floating point, 51
integral, 51
interval, 51
supported, 51

dataformats

delimited format, 37
fixed field definitions , 38
fixed length format, 38
SQL table format, 39

dataformats control file section, 37
datasource, description of, 54
date

date/time data type, 51

datetime

date/time data type, 51

decimal

integral data type, 51

deleteonerror, description of, 54
delimited data, 75, 76, 77
discards, description of, 54
Documents, related information, 9
double

floating point data type, 51

E

editor, control file, 119
enabletriggers, description of, 55
encoding, description of, 55
encryption

files, 25
utility, 26

endpart, description of, 57
endseq, description of, 57
Enhanced Initial Load

error logging, 19
error threshold, 20
exception table, 19
exception tables, 20
restrictions, 20

errors, description of, 58
exception table

structure, 19

exceptiontable, description of, 58
extract job, 69

considerations, 72
source, 69
steps to perform, 67
target, 69
virtual partitioned, 23
with delimited data, 77

F

faileddatafile, description of, 58
fixed width data, 75
float

floating point data type, 51

forcestaging, description of, 59

G

generator, control file, 121

I

IDENTITY column, 22

mapping, 22, 43

include control file section, 50
InlineSort, 19
inlinesort, description of, 59
installation

client directories, 17

int[eger]

integral data type, 51

integral data types, 51
interval

interval data type, 51

J

JMS, 21, 69, 70

messages, 71

jobs control file section, 48
jtrans command

-recover, 67
-run, 67
-version, 68

L

largeint

integral data type, 51

load job, 69

source, 69
steps to perform, 67
target, 69
transaction modes, 70
virtual partitioned, 23
with delimited data, 77

loadid, description of, 59
log files, 79
longint

integral data type, 51

M

maps control file section, 41
multi-session side-tree insert, 22
multipart, description of, 60

N

named pipes, 69
noaudit, description of, 61
nullstring, description of, 61
numeric

integral data type, 51

O

operation, description of, 62
options control file section, 30

P

parallel streams, 21, 69

134

Index