Results 1 to 3 of 3
  1. #1
    Join Date
    May 2012
    Posts
    155

    Unanswered: load command for csv --> decimal representation

    Hallo everyone,

    I have a csv with a column with such entries:
    +000005200.
    +000002000.
    +000003120.
    +000003153.
    ...
    ...

    These are already the datas (no more delimiters)

    I want to load this csv file, therefore I created the table with such ddl for the column:
    Code:
    columnName DECIMAL(9,0)
    My question is:
    will db2 automatically recognize and convert the entries appropiately as defined -decimal(9,0)- ??

    Thanks for the help.

    Regards,
    Ratna

  2. #2
    Join Date
    Nov 2011
    Posts
    334
    Why not test it by yourself?

  3. #3
    Join Date
    May 2012
    Posts
    155
    because I have "broken" my database. It is in the status "backup pending". So I will have to wait untill the backup is done.

    Thank you.

    Regards,
    Ratna

Posting Permissions

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