All Forums Tools
zhiyanshao 10 posts Joined 10/13
23 Oct 2013
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

You must sign in to leave a comment.