Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I'm looking for a simple SQL browser which supports DB2. I just want to be able to connect to a DB and try some queries.

share|improve this question
    
Which OS is your client on? –  Mark May 4 '11 at 9:15
    
Apologies, should have added a tag with the os. Windows.. –  jgauffin May 4 '11 at 9:22

2 Answers 2

up vote 2 down vote accepted

DBvisualizer supports DB2 as well as most databases, IBM Data Studio or DB2 Control Centre are specific for DB2. You can download and use them all free.

share|improve this answer
    
However, IBM Data Studio is the only that provides control for db2 features, like compression, pure scale, dpf, etc. –  AngocA May 21 at 11:53

Try MS office - Excel and Access have MSQuery which allows simple SQL queries through ODBC..

If your keys are correct then it will automatically join tables using foreign keys to the primary key in the other table - but you can override these if needed.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.