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

Tools & Utilities
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)