Converting the Data Types (SAP Library

Converting the Data Types

The SAP DB Loader can convert between numeric data types, if necessary.

You can use the external data type CHAR to read or output any internal database data type.

When loading data into a table, the specified external data type is converted to internal database data types and the corresponding column values of a table are loaded.
When unloading data from a table, the internal database types are converted to the specified external data types and the corresponding column values are unloaded.

	External Data Type	Internal Database Data Type
Loading data to a database instance	INTEGER, DECIMAL, ZONED, REAL	FIXED, FLOAT, SMALLINT, INT[EGER]
Unloading data from a database instance	FIXED, SMALLINT, INTEGER	INTEGER, DECIMAL, ZONED, REAL
Unloading data from a database instance	FLOAT	REAL or CHAR[ACTER]

Example

DATALOAD TABLE article
   ano         01-08
   descr       09-39
   stock      40-43 INTEGER
   min_ord    44-45 INTEGER
   ordered     46-49 INTEGER
   del_date 50-57
   price       58-65 DECIMAL (2)
   weight      66-69 REAL
INFILE 'customer.data' FORMATTED