Show TOC

Restrict Implicit Binary Conversion Mode for LOAD TABLELocate this document in the navigation structure

The restrict implicit binary conversion mode (CONVERSION_MODE set to 1) applies to LOAD TABLE with CHECK constraint or default value.

Example
CREATE TABLE t3 (c1 INT,
    csi SMALLINT,
    cvb VARBINARY(2),
    CHECK (csi<cvb));
SET TEMPORARY OPTION CONVERSION_MODE = 1;

This request:

LOAD TABLE t3(c1 ',', csi ',', cvb ',')
    FROM '/s1/mydata/t3.inp'
    QUOTES OFF ESCAPES OFF
    ROW DELIMITED BY '\n'

fails with the message:

"Invalid data type comparison in predicate
(t3.csi < t3.cvb), [-1001013] ['QFA13']"