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);
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