Page 1 of 1

How to save image files into Database

Posted: Mon Jan 26, 2015 7:44 pm
by yimwai
how to store the image files into blob( or other) column in database

Posted: Mon Jan 26, 2015 9:35 pm
by ray.wurlod
That's a database question.

DataStage does not support BLOB data type.

Posted: Tue Jan 27, 2015 6:40 am
by qt_ky
Not so sure; I have not tested it myself, but...

A quick 11.3.1 Knowledge Center search on BLOB indicates that the Oracle Connector, Teradata Connector, DB2 / DRS all support BLOB, but not ODBC. They suggest to use the DataStage data type of LongVarBinary.