Maps – HP Neoview Release 2.3 Software User Manual
Page 36
Only the simple data type name should be used. For example, if a table column named
FIRSTNAME is of data type varchar(8), you should specify “FIRSTNAME varchar”
instead of “FIRSTNAME varchar(8)”.
format formatname
one of the typeformats you defined in the typeformats section. This is optional and
not applicable for SQL columns.
options field-options
Defines options for the field. These field-options are supported:
•
•
Maps
The maps section describes how one data format is mapped to another when data is moved from
source to target.
maps
{
map-definition [, map-definition ]...
}
map-definition:
mapname from sourceformat to targetformat
field-mappings:
(
field-mapping-definition [, field-mapping-definition ]...
)
field-mapping-definition:
fieldname_target [ = field-source-ref]
[options field-mapping-options]
field-source-ref: {
fieldname_source [add | subtract] |
NULL |
default |
constant constant_value |
identity ( system | loader ) |
expression scalar-expression
}
field-mapping-options:
(
option_name = option_value [, option_name = option_value ]...
)
map-definition
One or more occurrences of map-definition, separated by a comma (,). The last
map-definition
should not use the comma separator.
mapname
The name you create for the map. The name must be unique within the maps namespace.
mapname
is case-insensitive and cannot exceed 64 bytes.
sourceformat
The source dataformat as defined in
For a load operation, sourceformat can be delimited or fixed-length dataformat.
For an extract operation, sourceformat must be an SQL table dataformat.
36
Control File Organization and Syntax