SQuirreL SQL Client is a graphical SQL client written in Java that allows us to view the structure of a JDBC compliant database, browse the data in tables, issue SQL commands etc. Follow below steps to configure SQuirreL for DB2 database.
- Download SQuirreL SQL Client and Download DB2 driver.
- Start SQuirreL client(It is a jar file,plain java application).
> java -jar <SQUrrel_Jar> - Open Driver list from left menu, click the plus sign "Create a New Driver". Fill the popup window as per following guidance and diagram.
Name = Any_name_as_per_convinience<IBM DB2 Universal Driver>
Example URL = jdbc:db2://<server_address>:<port>/<dbname>
website URL = www.ibm.com (optional)
Class Name = com.ibm.db2.jcc.DB2Driver
- Click Extra Class Path tab and browse DB2 driver downloaded above and click Ok.
- Create an alias out of this Driver created above. Open Aliases list and click plus - Create a new Alias. Fill out the popup window,Test connection and press Ok.
Name = Any_name_as_per_convinience
Driver = select driver same as created above(IBM DB2 Universal Driver)
UserName = <username>
Password = <passoword>
Tags:
Database
Great blog....waiting for next update...thanks fro sharing...
ReplyDeleteStruts Training in Chennai
struts classes
Struts Training institutes in Chennai
struts training in Thiruvanmiyur
struts Training in T Nagar
Wordpress Training in Chennai
SAS Training in Chennai
Spring Training in Chennai
Photoshop Classes in Chennai
DOT NET Training in Chennai
I would like to be your pen friend...You can write me email on genuinehotelescorts@gmail.com for
ReplyDeleteJaipur Escort
Jaipur Escort
Jaipur Escort
Delhi Escort
Guwahati Escort
Guwahati Escort
Guwahati Escort
Guwahati Escort
Lucknow Escort
Aerocity Escort
Mua vé máy bay tại Aivivu, tham khảo
ReplyDeletevé máy bay đi Mỹ
vé máy bay eva từ mỹ về việt nam
giá vé máy bay từ Toronto đến việt nam
é bay từ nhật về việt nam
Máy bay từ Hàn Quốc về Việt Nam
Vé máy bay từ Đài Loan về VN
شركة كشف تسربات المياه بالدمام
ReplyDeletehello
ReplyDeleteI must say that this is an excellent post, and I appreciate the information. You mention Configuration SQuirreL SQL Client for DB2 database : Execute SQL query from SQuirreL SQL client against DB2. Your arguments are so strong that I want to read more of them. Now, though, I'm looking for the Education Dissertation Topics service for a school assignment. I gain from this, and I do my assignment faster. The rich material on the website might be useful to all students.
ReplyDelete