Maps – HP Neoview Release 2.5 Software User Manual
Page 41
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.
targetformat
The target dataformat as defined in
.
For a load operation, targetformat must be an SQL table dataformat.
For an extract operation, targetformat can be delimited or fixed-length dataformat.
field-mapping-definition
One or more occurrences of field-mapping-definition, separated by a comma (,). The
last field-mapping-definition should not use the comma separator.
Control File Organization and Syntax
41