2 years ago

#47209

test-img

Odile Sips

Data truncated because data is longer than the target database column (IBM DB2)

I've been wanting to learn more about Data Analysis using IBM DB2 and SQL. I want to upload a Covid-19 open source dataset to practice. However I'm getting this error: 'Rows truncated because the data is longer than the target database column' The database isn't loading ANY rows. Do I need to change the datatype? Right now it is specified as VARCHAR and DECIMALS.

Does anyone know the best way to handle this error?

Thanks in advance!

Error: Data truncated because the data is longer than the target database column

sql

types

db2

varchar

0 Answers

Your Answer

Accepted video resources