- Open Eclipse, either using the start menu or desktop shortcut.
- Make sure your in the DBeaver perspective
- Window → Perspective → Open Perspective → Other
- Pick DBeaver from the list and click open.
- Window → Perspective → Open Perspective → Other
- 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:
- File → New → Project
- Pick a type of 'Project' under 'General', click next
- Give it a name, and click next.
- File → New → Project
- Create a connection
- Expand your project using the arrow to the left of its name, right click on the connections heading and pick 'Create a new connection'
- Pick 'DB2 LUW' from the list of connection types and then click next.
- 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
- Click 'Test Connection', Which indicates missing drivers click 'Download'.
- A successful test will provide the following:
- Expand your project using the arrow to the left of its name, right click on the connections heading and pick 'Create a new connection'
- Run a query against the data
- 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'.
- 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.
- 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'.
...