Loaddata is is working for db2 database

General Discussion
1

Hi Team,

I tried to load data from csv file to DB2 table. But it is not showing updateSQL , also when I run update command it is showing executed successfully but it didn’t really inserted data.

    <loadData schemaName=“DB2INST2”

            encoding=“UTF-8”

            file=“test.csv”

            quotchar="’"

            relativeToChangelogFile=“true”

            separator=","

            tableName=“PERSON”

            usePreparedStatements=“true”>

       

       

   

in test.csv

‘testuser’,‘testaddress’

2

Hi k20.sudarshana,

Would love to help, may I get some clarification?

  • Looking at your test.csv, I see only column headers, are you saying there is no data?
  • Could we see the commandline out put? maybe use --logLevel=FINEST argument to get more diagnostic data

Thanks,

Ronak