Topic
IC4NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
1 reply Latest Post - ‏2012-01-10T14:34:30Z by CiaranDeB
Sivagamigurusamy
Sivagamigurusamy
4 Posts
ACCEPTED ANSWER

Pinned topic SQL3125W The character data in row "F1-74588" and column "3" was truncated

‏2012-01-03T10:52:25Z |
I am facing the issue "SQL3125W The character data in row "F1-74588" and column "3" was truncated because the data is longer than the target database column" when loading data into db2 from sybase. Can anyone tellme how to interpret the row number F1-74588 ? I have a input file which is having around 1Lakh records. How to find which row in this?
Updated on 2012-01-10T14:34:30Z at 2012-01-10T14:34:30Z by CiaranDeB
  • CiaranDeB
    CiaranDeB
    1 Post
    ACCEPTED ANSWER

    Re: SQL3125W The character data in row "F1-74588" and column "3" was truncated

    ‏2012-01-10T14:34:30Z  in response to Sivagamigurusamy
    If you continue down the message file you should see a subsequent message detailing the line number that "F1-74588" refers to.