2 years ago
#47209
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!
sql
types
db2
varchar
0 Answers
Your Answer