Does IBM have a front end for DB2 for queries

[TrailblazerLS]

I have been using Access to query our mainframe DB2 tables. This works pretty well, but we would like to know if IBM-DB2 has some kind of front-end for developing queries.

 

[LKBrwnDBA]

SPUFI


----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[MarcLodge]

There are many different ways to access DB2, it depends upon your platform. Access works, although if you use Access interface to build the SQL, you will be hampering yourself. MS Query is another. And I believe that UDB2 has a PC based interface that allows you to query the tables.

It depends upon your platform, plus what you are happy with.

Marc

 

[ddiamond]

although if you use Access interface to build the SQL, you will be hampering yourself

If you want to stick with access, you can get around this limitation with access pass-thru queries. With pass-thru queries, you bi-pass the jet engine completely. That being said, we mostly use i-series navigator to access our AS400. I don't know if the main frame has anything similar.

 

[Truusvlugindewind]

No matter wich database you use, I recommend

http://www.querytool.com/

I am using at now at a client of mine and it works great: building SQL, testing stored-procedures: very easy!