Nov 17, 2015

Textual description of firstImageUrl

Configuration SQuirreL SQL Client for DB2 database : Execute SQL query from SQuirreL SQL client against DB2

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.
  1. Download SQuirreL SQL Client and Download DB2 driver.
  2. Start SQuirreL client(It is a jar file,plain java application).
    > java  -jar  <SQUrrel_Jar>
  3. 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
  4. Click Extra Class Path tab and browse DB2 driver downloaded above and click Ok.
  5. 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>
Now we are ready to execute SQL command from SQuirreL SQL Client. Right click on DB2 Alias and click connect.It opens a worksheet where we can execute SQL command.


Location: Hyderabad, Telangana, India

4 comments:

  1. I am glad that I saw this post. It is informative blog for us and we need this type of blog thanks for share this blog, Keep posting such instructional blogs and I am looking forward for your future posts. Python Projects for Students Data analytics is the study of dissecting crude data so as to make decisions about that data. Data analytics advances and procedures are generally utilized in business ventures to empower associations to settle on progressively Python Training in Chennai educated business choices. In the present worldwide commercial center, it isn't sufficient to assemble data and do the math; you should realize how to apply that data to genuine situations such that will affect conduct. In the program you will initially gain proficiency with the specialized skills, including R and Python dialects most usually utilized in data analytics programming and usage; Python Training in Chennai at that point center around the commonsense application, in view of genuine business issues in a scope of industry segments, for example, wellbeing, promoting and account. Project Center in Chennai

    ReplyDelete