Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2013
    Posts
    4

    Unanswered: Dynamic import in DB2 table

    Hi,

    I am using DB2 as my database and DataManager as ETL tool. I have a csv file as source. My Target has a fixed column definition but source can have lesser number of columns.
    Please help in how to proceed

    Thanks

  2. #2
    Join Date
    Apr 2008
    Location
    Iasi, Romania
    Posts
    561
    Provided Answers: 2
    As long as the missing columns from the csv are nullable and are the last ones in your table definition, you should be fine.
    Florin Aparaschivei
    DB2 9.7, 10.5 on Windows
    Iasi, Romania

  3. #3
    Join Date
    Jun 2013
    Posts
    4
    In above scenario say the target has 10 columns. But from source csv the structure coming is like below :

    scenario 1
    Column1,column3,column7

    scenario 2
    column1,column5,column9, column10

    is there any way to do this in Datamanager or through load utility of DB2? Please help

  4. #4
    Join Date
    Apr 2008
    Location
    Iasi, Romania
    Posts
    561
    Provided Answers: 2
    Both LOAD and IMPORT statements have METHOD P. I've never used this method, but you should read the documentation and then try on a test database.
    Florin Aparaschivei
    DB2 9.7, 10.5 on Windows
    Iasi, Romania

Posting Permissions

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