SQLSTATE=22001 while trying to load data.

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Pramoddb2
    New Member
    • May 2013
    • 1

    SQLSTATE=22001 while trying to load data.

    Hi,
    I am getting below error

    [IBM][CLI Driver] CLI0109E String data right truncation. SQLSTATE=22001

    while trying to load data using an local application T05 in my project.

    this is an JAVA based application using DB2 and mainframe as back end.
    this application was working fine on XP (and DB2 V7) we are getting this issue after we upgraded to Windows 7 (64 bit) and (DB2 Personal edition V9.7).
    So I am assuming that there may be some issue related to windows7 up-gradation. Is there something I am missing.

    After google I came to know there may be some patch I need to install but now that patch is no longer available.
    http://support.microso ft.com/kb/239458
Working...