Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2006
    Location
    Pune , India
    Posts
    433

    Lightbulb Unanswered: Failing Import with Decimal Data type

    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

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    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

  3. #3
    Join Date
    Jul 2006
    Location
    Pune , India
    Posts
    433
    thanks
    i missed the obvious
    will change data type to char/varchar

    --Rahul

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •