Cynthia

Cynthia

  • NA
  • 215
  • 35.9k

.Net application gives error SQL0433N Value <Lob-value> is too long

Jun 14 2023 3:41 AM

I have a .Net application 4.5 where we are doing bulk loading of data from  table (DB2 V10 is database) based on user defined ID through stored procedure where the UID_Field VARCHAR (32000). Sometimes , bulk loading of data fail and we get the error as ERROR[2201][IBM][DB2] SQL 0433N Value "" is too long . The SP used CONCAT function for UID_Field for query results .

My worry is only sometimes we get this error even when there is not much data , i mean the length doesn't exceed 32000 and mostly it works fine. I am trying to understand why this error is coming even though length size is 3000 only .

Is there any way to resolve this issue from .net application  ?


Answers (1)