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 ?