I have a table having column SSFT2 decimal(10,2) as PK and using following import command
IMPORT FROM "D:\DBTeamBkp\DailyBKP\CSV2.txt" OF DEL MODIFIED BY IMPLIEDDECIMAL COLDEL, MESSAGES "D:\DBTeamBkp\DailyBKP\msg2.log" INSERT INTO EONE.TSCH_LA_SBCTGRY_temp (SSFT2, SUBCATEGORYNAME);

Sample data
8.1," Sport, Leisure and Recreation"
8.10," Sport, Leisure and Recreation123"

problem is while importing the second line , database is rejecting it as it is reading the first line as 8.10 instead of 8.1. please tell me the appropriate option for decimal so that it will read first line as 8.1 and not 8.10

--Rahul Singh

DECIMAL is a numeric field not character. This means that 10.1 and 10.10 are the same value. Since this is a PK, they are duplicates and the second one is rejected.

Andy

thanks
i missed the obvious
will change data type to char/varchar

--Rahul