Trying to import some data, and getting a strange error: Error importing record 0:  Overflow occurred computing an expression involving test_fusf.Subscriber_No
Only 0 rows were loaded.
A sample of the data I'm trying to upload is below (don't worry, no SSNs or anything sensitive).
the table I created is below. The imported file is a CSV. I made sure to skip the header row, set the delimiter to comma... not sure what I'm missing. The subscriber number in some cases is a 0, and in others is a 10 digit number.
create volatile table test_fusf (BAN number,Subscriber_No integer,product_type varchar(1),Tax_Type integer,Tax_Auth integer,Effective_Date date,Expiration_Date date,CC_PC_CODE integer)ON COMMIT PRESERVE ROWS;
Solved! Go to Solution.