bergertime
asked on
iSeries Query Designer
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. ??
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I havent used that. It sounds cool. Glad to hear that you liked WebQuery. I really liked it also, and that was at 1.1.1 which was no where near 1.1.2 and apparently 2.1. Now you have me anxious to try 2.1 :)
Thanks!
Thanks!
Haven't used IB mobilefaves.
ASKER
Thank you. :)
ASKER
I did try squirrel, couldn't get it to work. Tried aquafold and it was very nice.
On additional question if I might. Have either of you used the IB MobileFaves? It's a native app for iOS built by the same people who built Web Query, but for the life of me I can't get it to connect and info seems to be lacking. Anyway, thanks again, if I don't hear anything else I'll award points tomorrow.