Clover ETL data type equivalent to BLOB of DB2

maniatindia

• August 22, 2007 00:00

• Answered

Follow

Do any one have an idea on what should be the Clover Data type for BLOB Data type of DB2, i am working with DB2 and i am facing this problem. i tried with string but i am getting the error like this.

maximum # of errors exceeded when inserting record: Illegal Conversion caused by: java.sql.SQLException: Maximum # of errors exceeded when inserting record: Illegal Conversion

let me know do any one have idea on this.

This is rama from India.

• 

  mzila

  • August 23, 2007 08:37

  0

  Comment actions Permalink

  You should use Clover byte data type if you want to save it to BLOB database field.
  If you need to transform Clover string to Clover byte first, you need to write something like this ${in.0.STRINGFIELD}.getBytes() in in-line transformation.
• 

  maniatindia

  • August 24, 2007 05:48

  0

  Comment actions Permalink

  Thanks mzila,

Please sign in to leave a comment.