BTEQ Failure 2673 while importing the data file if the table has "not null" column

Tools
Enthusiast

BTEQ Failure 2673 while importing the data file if the table has "not null" column

Hi,

I am trying to export the table to a data file, clear the table and use ".import data file" to import the data back in.  I always got the following error if the table has a "not null" column. 

*** Failure 2673 The source parcel length does not match data that was defi

 ned.

Here is the table:

CREATE MULTISET TABLE testdb.testio ,NO FALLBACK ,

     NO BEFORE JOURNAL,

     NO AFTER JOURNAL,

     CHECKSUM = DEFAULT,

     DEFAULT MERGEBLOCKRATIO

     (

      setting VARCHAR(128) CHARACTER SET LATIN CASESPECIFIC NOT NULL,

      int_value INTEGER,

      float_value FLOAT,

      date_value DATE FORMAT 'YY/MM/DD',

      decimal_value DECIMAL(20,2),

      NotNullDec_value DECIMAL(20,2) NOT NULL DEFAULT 1.02 , 

PRIMARY KEY ( setting ))

;

However, it works if the "NotNullDec_value" column is not there. Can anybody help me on this?

Thanks,

Zhiyan

Tags (3)