Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
  1. Open Eclipse, either using the start menu or desktop shortcut.
  2. Make sure your in the DBeaver perspective
    1. Window → Perspective → Open Perspective → Other
    2. Pick DBeaver from the list and click open.
  3. Make sure you have a project in your workspace, these appear in the projects pane on the left hand side. Only if you don't already have a project, create one:
    1. File → New → Project
    2. Pick a type of 'Project' under 'General', click next
    3. Give it a name, and click next.
  4. Create a connection
    1. Expand your project using the arrow to the left of its name, right click on the connections heading and pick 'Create a new connection'
    2. Pick 'DB2 LUW' from the list of connection types and then click next. (NOTE: For the new Windows 10 SAIL, please search and select 'DB2 LUW UKSeRP')
      Image Removed 
    3. Enter the host and database names, also enter your username and if you wish password. Click Finish.
      The host and database should be set to:
      Host: db2.database.ukserp.ac.uk
      Database: pr_sail
  5. Run a query against the data
    1. Either open an existing SQL file from your existing project or create a new one by right clicking within your project and choosing 'Create SQL script'.
    2. Use the yellow arrow to the left hand side of the SQL editor to run your query. The results will show in the pane at the bottom of the screen.

...