# Loaddata is is working for db2 database

**URL:** <https://forum.liquibase.org/t/loaddata-is-is-working-for-db2-database/4088>\
**Category:** General Discussion\
**Created:** [February 25, 2020, 2:27pm UTC](https://forum.liquibase.org/t/loaddata-is-is-working-for-db2-database/4088 "2020-02-25T14:27:00Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![k20.sudarshana](https://avatars.discourse-cdn.com/v4/letter/k/b2d939/32.png) [@k20.sudarshana](https://forum.liquibase.org/u/k20.sudarshana)\
**Post date:** [February 25, 2020, 2:27pm UTC](https://forum.liquibase.org/t/loaddata-is-is-working-for-db2-database/4088/1 "2020-02-25T14:27:00Z")

</div>

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.

&nbsp; &nbsp; \<loadData schemaName=“DB2INST2”

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; encoding=“UTF-8”

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; file=“test.csv”

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; quotchar="’"

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; relativeToChangelogFile=“true”

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; separator=","

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; tableName=“PERSON”

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; usePreparedStatements=“true”\>

&nbsp; &nbsp; &nbsp; &nbsp;

&nbsp; &nbsp; &nbsp; &nbsp;

&nbsp; &nbsp;

in test.csv

‘testuser’,‘testaddress’

---

<div class="post-metadata">

**Author:** ![un93640144089160208r](https://avatars.discourse-cdn.com/v4/letter/u/41988e/32.png) [@un93640144089160208r](https://forum.liquibase.org/u/un93640144089160208r)\
**Post date:** [February 25, 2020, 2:27pm UTC](https://forum.liquibase.org/t/loaddata-is-is-working-for-db2-database/4088/2 "2020-02-25T14:27:00Z")

</div>

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