var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: How to read excel sheet column from db2 script
I have to create a db2script to update the column value after reading that value from an excel sheet
simple solution is to use a User Defined Function
CREATE FUNCTION (external scalar) - IBM DB2 9.7 for Linux, UNIX, and Windows
You can do one in C, Java, CLR or OLE
Federation using Information Integrator is an option if you want to join excel sheet with DB2 tables.
Federated access to Excel from DB2 9.1.1 on Linux
Visit the new-look IDUG Website
, register to gain access to the excellent content.
without external functions
without the usage of external functions , any other methods to read the excel data into db2 scripts
Tags for this Thread