This was a considerable feat considering the fact that I didn’t read the manual. Sign in or register to add and subscribe to comments. Let’s add a few sample records in our new table: Comments Sign in or register to add and subscribe to comments. For demonstration purposes, the table will be kept simple. Next you’ll need to modify the URL.

Uploader: Akizshura
Date Added: 22 June 2007
File Size: 24.1 Mb
Operating Systems: Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X
Downloads: 33689
Price: Free* [*Free Regsitration Required]

The graphical front end is built to support JDBC-compliant squirreo. Stack Overflow works best with JavaScript enabled. Download the install JAR from http: Wouldn’t it be nice to have a single, simple front end application that you can use to interact with the myriad of database flavors you have to have your taste of throughout the day?

Support for the client can be acquired through mailing lists which can one can subscribe to via the SQuirrel Client home page. I’ll assume that your username and password are db2admin and db2admin respectively:.

As it is quite likely that the databases you are dealing with will not reside on sqirrel same physical machine, SQuirreL client has built in support for using HTTP proxies and SOCKS proxies to interact with databases that might reside somewhere on the Internet.


SQuirreL intelligently detects if the JDBC driver for a given database is in your classpath; if not, you’ll see an “X” next to the driver.

I followed the answer and the comment by Gas, only it complains for license during adding alias. Sign in or register to add and subscribe to comments. Sign up using Facebook.

Next you’ll need to modify the URL. Each of these databases has its own database client tools which are all different. By clicking “Post Your Answer”, you acknowledge that you have read our updated terms of serviceprivacy policy and cookie policyand that your continued use of the website is subject to these policies. Comments Sign in or register to add and subscribe to comments.

If you are using DB2 7.

Thorsten Niehues 6, 10 48 SQuirreL detects the existence of db2java. After squirrwl connecting, you will be shown a new ddb2 in which you will be able to interact with the database. Take some time to see what information is offered through the various tabs. I was quite impressed by the ease of install of the SQuirreL Client. One of the plugins I found quite interesting was developed by the head developer, Colin Bell.

How to setup the Squirrel to Connect to DB2?

If you are using DB2 V8, this db2java. Life would even be sweeter if such an application were free. Subscribe me to comment notifications. While the application works fine in Java 1.


As it is already a powerful offering, it will be interesting to see what future versions of the application will bring. To execute the SQL statement, simply click the running man icon as shown in Figure 9. But they are sqirrel marked with an red X. Notice that the results of the query are shown in table form.

Configure SQuirreL SQL Client for DB2 for Linux, UNIX, and Windows | Auroran Runner

Join Stack Overflow to learn, share knowledge, and build your career. If there is a JDBC 2.

SQuirreL SQL Client allows for users to install squirre create plugins that are designed to augment the functionality of the base application. I checked with Start Page but did not find an easy solution: The figure below shows the results of the query we issued.