Column size too large when writing to DB2 DB

Moderators: statman, Analyst Techy, andris, Fierce, GerineL, Smash

Posts: 1
Joined: Tue Nov 06, 2012 2:59 pm

Column size too large when writing to DB2 DB

Postby sdstrand » Tue Nov 06, 2012 3:20 pm

I have a stream that writes data to a db2 database. I am getting the following error when running the stream:

"The size of String or binary data is too large for column, it should be truncated."

I have a column of names that I am writing into the db. The db2 database column has a data type of long varchar (32700 bytes). Whenever the length of the column exceeds 2100 characters, I get this error.

What am I missing?

Any help is appreciated. BTW, I am using Modeler Premium version 15.0.

Who is online

Users browsing this forum: No registered users and 1 guest