Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2009
    Posts
    2

    Unanswered: Import CSV not working in primary keys

    Hi,

    I have a csv file and when I import into the DB2, it gets imported.

    But, when there is a primary key in the column of the same table, the value does not get imported.


    I need your suggestions

    the command I used is IMPORT from "d:\\gg1.csv" of DEL INSERT INTO EMPLOYEE

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    DB2 Database for Linux, UNIX, and Windows

    lookout for identityignore , identitymissing on this page


    Cheers
    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    You can also alter your identity column to be "generated by default" instead of "generated always".
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  4. #4
    Join Date
    Nov 2009
    Posts
    2

    New Issue

    Hi Thanks for your suggestions, friends.

    Now I face new problem.

    I have number datatype in oracle

    similarly smallint in db2

    when i convert the datas it comes as a null value....

    need suggestions...

    (What will be the appropriate to convert number data type in oracle to db2??)

Tags for this Thread

Posting Permissions

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