Syntax documentation numerical_functions Locate the document in its SAP Library structure

Syntax Rules for Column Descriptions

Syntax

<numerical_functions> ::= <scale_spec>
| <round_or_trunc_spec>
| <scale_spec> <round_or_trunc_spec>

Use

Use this syntax rule to scale, round, or shorten numeric data values when you load data from the data stream to the target table or unload data from the source table to the data stream.

Note

Note that you must always specify scale_spec before round_or_trunc_spec.

Example

DATALOAD TABLE distance
  ...
  cm 7 SCALE 2
  cm 7 SCALE -3 ROUND 1
...
INFILE 'meter.data'

Example

DATAEXTRACT * FROM distance
  cm    10-14 INTEGER SCALE 2
  m     14-17 INTEGER
  km    18-21 INTEGER SCALE -3 TRUNC 2

OUTFILE 'dimensions.bin' FORMATTED