By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,287 Members | 1,309 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,287 IT Pros & Developers. It's quick & easy.

Error SQL0433N - Value is too long UDF issue

P: n/a
I have a function that has a varchar about 300 characters. When I run
the insert command from a function I receive the error SQL0433N -
Value .... is too long SQLSTATE=22001.

If I run the query outside of the function it seems to work fine. I
read about char limitations of 255 characters does a user defined
function (UDF) limit me with 255 characters as well?

Mar 14 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a

The string was casted with char(). Therefore it was limited to 256
characters. Issue solved.
On Mar 14, 11:09 am, "Justin" <kfw...@hotmail.comwrote:
I have a function that has a varchar about 300 characters. When I run
the insert command from a function I receive the error SQL0433N -
Value .... is too long SQLSTATE=22001.

If I run the query outside of the function it seems to work fine. I
read about char limitations of 255 characters does a user defined
function (UDF) limit me with 255 characters as well?

Mar 14 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.