# Clover ETL data type equivalent to BLOB of DB2

**URL:** <https://forum.cloverdx.com/t/clover-etl-data-type-equivalent-to-blob-of-db2/208>\
**Category:** CloverDX Platform\
**Created:** [August 22, 2007, 12:00am UTC](https://forum.cloverdx.com/t/clover-etl-data-type-equivalent-to-blob-of-db2/208 "2007-08-22T00:00:00Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![maniatindia](https://avatars.discourse-cdn.com/v4/letter/m/22d042/32.png) [@maniatindia](https://forum.cloverdx.com/u/maniatindia)\
**Post date:** [August 22, 2007, 12:00am UTC](https://forum.cloverdx.com/t/clover-etl-data-type-equivalent-to-blob-of-db2/208/1 "2007-08-22T00:00:00Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![mzila](https://avatars.discourse-cdn.com/v4/letter/m/5fc32e/32.png) [@mzila](https://forum.cloverdx.com/u/mzila)\
**Post date:** [August 23, 2007, 8:37am UTC](https://forum.cloverdx.com/t/clover-etl-data-type-equivalent-to-blob-of-db2/208/2 "2007-08-23T08:37:51Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![maniatindia](https://avatars.discourse-cdn.com/v4/letter/m/22d042/32.png) [@maniatindia](https://forum.cloverdx.com/u/maniatindia)\
**Post date:** [August 24, 2007, 5:48am UTC](https://forum.cloverdx.com/t/clover-etl-data-type-equivalent-to-blob-of-db2/208/3 "2007-08-24T05:48:16Z")

</div>

Thanks mzila,
