We have an iSeries version on os 7.1. I need to know if there is a query designer? Like the one from SQL server mgmt studio. I can use the one in iSeries Navigator, but it's cumbersome, I've linked it to my SQL Server 2008 R2, but the query builder dosen't work on it. I can see the data, just can't build a query. So right now I use three different ways to get ad hoc queries out of it. I can build them in the green screens, build them using Navigator, or, since I'm usually in visual studio add a sqlDataSource and build it that way. There has to be a decent gui Query Designer for the 400. ??