Large Files

ratheeshknair · #1 (**permalink**) 10-22-09, 05:00

Hi Experts,

How can i stored large files in a table?

I am having more than 200 XSD & XLS files.

Please help

TIA

stolze · #2 (**permalink**) 10-22-09, 13:29

You create the table with a column of type XML, CLOB, or BLOB (whatever suits you best) and then insert the data in this column.

ratheeshknair · #3 (**permalink**) 10-23-09, 06:06

Thanks Stolze,
How can i insert a file in a column?

Can you give me an example?

TIA

stolze · #4 (**permalink**) 10-24-09, 13:01

You read the file into a variable in your program and then insert the variable in the table. Alternatively, if the file happens to reside on the database server, you can use a UDF as I did in this article for similar purposes to load images into a BLOB column: A DB2 UDB still image extender

Internet Services

Web Development

Digital Marketing

Consumer Tech