I'm brand new to the site and relatively new to the iSeries having come from the SQL Server platform and in the environment I'm working in I find the query manager on the AS400 extremely unproductive.
I've done some research and I see there are ways to connect to the AS400/DB2 using ODBC/JDBC which can then in turn be used with some free SQL clients.
First, what FREE SQL clients are people using? The best one I see is SQuirell SQL, but I'm open to other FREE suggestions (please under NO CIRCUMSTANCES should you respond with a client that has any cost).
Can anyone help me on what I need to do with these files? The ODBC extracts to a series of folders, but there's no read me and therefore I'm not sure what I'm doing. The JDBC seems slighly more compact, but again I'm not sure what I should be doing with the files (I'm using Windows... again, please answer the question I've asked and don't ask me to download the entire run-time client or iSeries access since neither of those are an option. Please forgive me, but I've been on enough boards where people say "why don't you try this as an alternate solution" when I'm asking for a specific answer to this specific issue).
When you decide on which SQL client you want to use, you will probably need some setup with it to connect to your DB2 database. During this process, it will want to know where the JDBC drive is. So just put the drivers in an easy to find directory for now.