Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2012
    Posts
    2

    Unanswered: Import .csv file with one column set as auto increment and one as current timestamp

    Hi,

    I want to import data from .csv file into db2 database where one column value is set to auto increment and one more column value set to current timestamp.
    In this case is it required to mention these columns in .csv fiile. If yes what will be values of these. I tried with null values for these columns but is giving me following error message

    SQL3120W The field value in row "1" and column "1" cannot be converted to an
    INTEGER value, but the target column is not nullable. The row was not loaded.

    Anybody has idea about importing in such scenario.

  2. #2
    Join Date
    Jan 2012
    Posts
    2
    I m using Control Center utility for Import

  3. #3
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1

Posting Permissions

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