Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2013
    Posts
    2

    Unanswered: How to read excel sheet column from db2 script

    Hi

    I have to create a db2script to update the column value after reading that value from an excel sheet

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    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.

  3. #3
    Join Date
    Mar 2013
    Posts
    2

    without external functions

    without the usage of external functions , any other methods to read the excel data into db2 scripts

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •