Hp Neoview Release 2.3 Software Manuel d'utilisateur télécharger pdf (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:

• “crossoveryear” (page 47)

• “nullstring” (page 51)

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 “Dataformats” (page 32).

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

1 2 ... 31 32 33 34 35 36 37 38 39 40 41 ... 109 110

Commentaires sur ces manuels

Pas de commentaire

Hp Neoview Release 2.3 Software Manuel d'utilisateur Page 36

Commentaires sur ces manuels

Produits connexes et manuels pour Logiciel Hp Neoview Release 2.3 Software