Allow numeric data to be in binary format (BINARYNUMERICS)

Select this check box to allow binary data values to be loaded into NUMERIC table columns. Binary data includes INTEGER, SMALLINT, FLOAT, and REAL data.

If you select this check box, you must also select the Record length in characters check box and specify the length of the records. Also, the Do not recognize character x'1A' as the end-of-file character (NOEOFCHAR) modifier is implicitly assumed, even if you do not select that check box.

The following rules apply for binary data values that are loaded into NUMERIC table columns:

• No conversion between data types is performed, other than for INTEGER and SMALLINT data.

• Data lengths must match their target column definitions.

• FLOAT data values must be in IEEE Floating Point format.

[ Top of Page | Table of Contents | Glossary | Index ]

[ DB2 List of Books | Search the DB2 Books ]