Forum Discussion

SJLamb's avatar
SJLamb
Copper Contributor
Aug 21, 2020

"Basic" SQL editor required for ODBC connection to DB2

In Office 365 I now have to use the Data tab to establish an ODBC connection to a DB2 for z/OS database, selecting "From other sources", "From ODBC" and then connecting to the DB2 database. I can en...
SJLamb's avatar
SJLamb
Copper Contributor
Aug 24, 2020

SergeiBaklan 
Hi Sergei,

 

I think there's probably something wrong with my setup, as I can't use the legacy Data Connection Wizard option in 365. If I select this and chose my DB2 database, Excel just disappears - no error messages on the screen at all. I don't know why / how this is different from establishing an ODBC connection from Other Sources. I'll see about raising a fault with our internal support team.

We've recently migrated from Win 7 to Win 10 and I've had to update my IBM ODBC drivers to a new version as well.

 

Some of my source tables have about 400 columns and I might only want 20 columns in my data, so it's much easier if I can use an existing SQL query rather than having to remove 380 columns 🙂

 

Thanks for your help

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Aug 25, 2020

    SJLamb 

    Sorry, I had no experience with DB2, have no idea what could be an issue with the driver.

     

    Of course, if you are more comfortable with SQL query, use it. I also use native queries from time to time, it depends on concrete project. The only my point PQ editor is not designed to work with SQL from user interface.

     

    Just in case, for your sample it's not necessary to remove 380 columns, it's enough to select 20. That's easy enough from user interface only

Resources