Toad World® Forums

does Toad for DB2 able to query PC SAS?

does Toad for DB2 able to query PC SAS? Thanks in advance.

I am not sure I understand your question or environment.
Toad DB2 supports connecting to DB2 LUW databases or DB2 z/OS subsystems.
If you have a SAS environment that runs on one of those then, yes Toad will support that.
If you do not have a SAS environment that runs on DB2, then you will have to do something like:

  • extract your SAS data to a csv or xls file
  • in Toad DB2
    • connect to your DB2 database/subsystem
    • import your SAS data into DB2 tables
      • then you can use Toad DB2 to get at your SAS data that is within DB2
        Hope this helps.

Hi Jeff, thanks for the inputs. appreciate it. :slight_smile: