SQuirreL SQL Client

SQuirreL SQL Client is a graphical Java program that will allow you to view the structure of a JDBC compliant database, browse the data in tables, issue SQL commands etc, SQuirreL's functionality can be extended through the use of plugins.

SQuirreL SQL is open-source software. It provides an editor that offers code completion and syntax highlighting for standard SQL. It also provides a plugin architecture that allows plugin writers to modify much of the application's behavior to provide database-specific functionality or features that are database-independent. 

The SQuirreL client leverages a database's JDBC driver to facilitate conversation with a database. Officially, the client supports a myriad of database products, including the major players: IBM DB2, Oracle, Microsoft SQL Server, Informix, Sybase, and MySQL. If there is a JDBC 2.0 available driver for your database, you can register the database manually with the client.

The ability to interact with databases of different vendors via a single interface is one of the key offerings of SQuirreL. As it is quite likely that the databases you are dealing with will not reside on the 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.

Supported Database.
· Axion Java RDBMS.
· Apache Derby
· Daffodil (One$DB)
· Fujitsu Siemens SESAM/SQL-Server with the SESAM/SQL JDBC driver
· Firebird with the JayBird JCA/JDBC Driver
· FrontBase
· Hypersonic SQL
· H2 (DBMS)
· Informix
· IBM DB2 for Linux, OS/400 and Windows
· InstantDB
· Ingres
· Mckoi SQL Database
· InterBase
· Microsoft Access with the JDBC/ODBC bridge.
· Microsoft SQL Server
· Mimer SQL
· MySQL
· Oracle Database 8i, 9i, 10g, 11g
· Netezza
· Pointbase
· SAPDB
· PostgreSQL 7.1.3 and Higher
· Sybase
· Sunopsis XML Driver (JDBC Edition)
· Teradata Warehouse
· Vertica Analytic Database.
· ThinkSQL RDBMS

Features:
· Object Tree allows for browsing database objects.
· The SQL Editor is based on RSyntaxTextArea by fifesoft.com to provide syntax highlighting. It can be used to open, create, save and execute files containing SQL statements.
· Supports simultaneous sessions with multiple databases.
· Graph capabilities to create charts showing table relationships.  

Installing SQuirreL SQL:
From command prompt run the bellow command:

Java –jar file path/Downloaded Squirrel jar file name.jar

Once you run the jar file you will be prompted with the installation screen, keep press Next button on all the screens till you reach the bellow shown screen.

Select "Optional Plugin - DB2" when you are prompted.

Running the Application:

When you start the application, you will get the splash screen and then you will see the application screen. In the application screen, click on the Drivers tab on the left.

To set up the driver, select the JTOpen(AS/400) driver and then click on the pencil icon in the tool bar directly above the driver list.
On the Change Driver Window, click on the Extra Class Path tab. Then click on the Add button and navigate into the folder where you downloaded your JTOpen jar file.

(Note: You need to download the JTOpen from http://jt400.sourceforge.net/)

Once the driver is set up, you need to configure the application for your IBM i. Click on the Aliases tab on the left of the application screen. Then click on the blue plus sign (+) in the tool bar above the empty list box to add a new alias.

· In URL box follow the bellow standard to setup a connection with IBM i.

         o jdbc:as400://IBM i Name/Test Library

· Select Driver as JTOpen(AS/400).

· Give the User Name and password.