Results 1 to 3 of 3

Thread: Data import

  1. #1
    Join Date
    Apr 2007
    Posts
    51

    Smile Unanswered: Data import

    Can I import in Qmf for windows a file from other sources (in this case it's a job that has elaborated DB2 data, but I could be in the need of using for instance Excel files or others) and compare its fields with DB2 tables in my query?

    Thank you.

    Anna - Verona (Italy)

  2. #2
    Join Date
    Jun 2006
    Posts
    471
    you can
    you have to activate odbc sources in qmf/admin
    declare the excel sheets as odbc sources
    but you can not select data from db2 and excel at the same time in the same query, for this, you need the non-relational wrappers (federated databases)
    and declare these sheets as nicknames for db2
    Best Regards, Guy Przytula
    DB2 UDB LUW certified V6/7/8

  3. #3
    Join Date
    Sep 2004
    Location
    Belgium
    Posts
    1,126
    Quote Originally Posted by guyprzytula
    but you can not select data from db2 and excel at the same time in the same query
    The simplest way for this is then probably to load the data returned from one source (viz. excel) into a new table at the other side (viz. DB2); would that be possible?
    --_Peter Vanroose,
    __IBM Certified Database Administrator, DB2 9 for z/OS
    __IBM Certified Application Developer
    __ABIS Training and Consulting
    __http://www.abis.be/

Posting Permissions

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