PowerWire.eu

Independent IBM i, AIX and Linux news and tech tips for Europe and beyond

  • Home
  • News
  • Technical Articles
    • IBM i
    • AIX
    • Linux
    • VIOS
  • Subscribe
  • About Us
  • Contact Us
  • Advertise with PowerWire.eu

Use the Beaver!

April 29, 2019 by Andy Youens

Use the Beaver!

In this article I will show you how we can use beneficial plugins to enhance our RDi environment.

If you find the Run SQL Scripts limited in its functionality, not being able to prompt SQL statements, no auto-complete etc, then the Beaver may be for you!

DBeaver is free and open source universal database tool for developers and database administrators.

It supports all the usual databases, including our DB2.

The latest version, version 6.0.3 was released on the 21/04/19.

Installation

The easiest way to install DBeaver is through the Eclipse marketplace, which can be found under the Help menu.

Use the search facility to narrow your search.

Follow the install instructions to install DBeaver.

If you are having difficulty using the Eclipse marketplace, it can be downloaded and installed manually from here.

RDi Perspective

Once installed, use the DBeaver perspective. This can be seen in the figure below.

To create a new connection to our IBM i, click on the New Connection button (shown below), or use the CTRL + N shortcut.

Select the DB2 for iSeries/AS400 option and follow the wizard to create a new connection.

Once the connection is completed, we can expand on the new connection and see all our libraries/schemas, and drill down to see additional details.

Features

Let me show you some of the useful features in this plug-in.

Searching

Searching for any database object is easily performed using the search box. This is shown in the figure below.

Easy to use and very fast.

Quick View

To easily see the contents of a table, just right click and select Read Data in SQL Console

And, voila, all records are shown. Additionally, you can also filter the results by using the Ctrl + Space shortcut.

Auto Prompting

A very useful feature is the auto prompting. When we start typing a SQL statement, the beaver will automatically show us the columns and their attributes. Stops some of my typos!

Current Schema

Another one to stop my typo’s – My days in the Royal Navy, where they taught me to type, is far in the distance!

Look for the toolbar option to set the current schema, as shown obove. It even provides a drop-down list of all schemas on our box.
Another very useful feature.

Create Table Wizard

The Create Table Wizard assists those for whom the Create Table SQL statement doesn’t roll off the tongue.

 

1. Right-click the schema, or Table section > Create >Table
2. Enter the name of your new table
3. Right-click in the column section > Create > Column
4. A new window will allow you to input the column attributes
5. Click the Save button on the lower toolbar

Once the Save button is pressed, a summary will be displayed prior to creating the table.

These are just a small number of the features in this impressive package. I’m sure you can find more, let me know your favourite.

Conclusion

Hopefully, this article has given you an insight on how we can include additional packages into our RDi environment. Yea, I know there are other options to access our database, but I have found this one to be very useful.

If you have any questions, let me know.

I’m looking forward to the next round of the i-UG user group meetings this year in the UK, the International i Power 2019 conference on the 11th & 12th June 2019. Hopefully we can meet up at the main event of the year at our local football stadium in Milton Keynes. Full details can be found on the iUG site here.

Andy Youens is an IBM i consultant/instructor at Milton Keynes, UK-based FormaServe Systems with over 39 years IBM midrange experience.

Related Posts

  • IBM i DashboardIBM i Dashboard
  • Did IBM just offer you a FREE HMC?Did IBM just offer you a FREE HMC?
  • SMBv3 support in IBM i 7.4SMBv3 support in IBM i 7.4
  • IBM i Conference in the UKIBM i Conference in the UK
  • RDi 9.6 – Worth a Look?RDi 9.6 – Worth a Look?
  • Back to the futureBack to the future

Filed Under: IBM i, Technical Articles Tagged With: i-UG, IBM i, IBM Power Systems

Comments

  1. Russ Khoury says

    May 8, 2019 at 1:10 pm

    H i Andy, thanks for the info on this plug-in. Just tried it – they’re up to 6.0.4 now. But the #$%@! security here had an issue with the certificate so the install failed. It seems RDi is good about rolling back from a failed install. I’m going to see if this can be overcome. Looking forward to your future articles.

Free monthly newsletter signup

News

Raz-Lee Security Announces IBM i Security Bundles

Nanuet, New York – December 4, 2019 – Raz-Lee Security is pleased to announce that they are now offering IBM i … [Read More...]

HelpSystems Announces Clearswift Acquisition to Expand Cybersecurity Portfolio

MINNEAPOLIS, December 2, 2019 – HelpSystems announced today that it will acquire Clearswift, a UK-based … [Read More...]

TD/OMS and Gravity “Milestone 1” Enhancements Streamline Efficiency and Advance Application Development Potential for Remain Software Customers

Remain Software released this Wednesday TD/OMS V12 Milestone 1 and Gravity V5 Milestone 1, in line with the … [Read More...]

More articles from this section

Quick Links

  • Advertise
  • Subscribe

Follow Us…

  • Email
  • LinkedIn
  • Twitter

Search This Website

Copyright © 2019 · Cue Communications · All Rights Reserved · RED NOISE MEDIA

Copyright © 2019 · Magazine Pro Theme on Genesis Framework · WordPress · Log in

This site uses cookies More info