Welcome to Db2Connect for Visual Studio Code! An extension for connecting to IBM Database servers and performing database operations including:
- Connect to IBM Database servers.
- Create and manage connection profiles.
- Write sql statements to do DDL and DML operations.
- Execute sql statements and view results in a simple to use grid.
Option 1 Select this option if you have a connection string handy.
Option 2 Select this option to provide individual parameters
In this option, the individual connection parameters like Database, Hostname, Port, Userid, Password can be specified.
Selecting the Connect option attempts a connection to database server and displays the status message.
Option 3 Connect using one of your saved Connection Profiles
In this option, selecting an existing profile to connect is provided.
Disconnects the current opened connection.
Db2: Manage Connection Profile
Through this option, its possible to Create or Edit profile information. A profile information contains the database connection string.
Manage Connection Profile has two options:
Creates a new profile containing details such as Database Name, Hostname, Port, Userid and password.
This option allows editing of existing profiles. This option opens a GUI where user has to select the profile and edit the profile details.
This option allows the user to delete the profile.
This option can be used to execute DDL and DML statements except select on the connected database objects. Before using this option, it is required to connect to the database using the Connect option. The results of doing database operations is displayed through the message dialog in the right bottom corner of VS Code editor.
This features provides support for querying the database objects. The results of this execution will be displayed on the right hand side of VS Code window.
Db2: View Command History
This option opens a file where a list of user executed queries for a session are stored.
Db2: Rebuild Native Modules
This option is used when a new version of an electron is introduced into the vs code Editor. One can use this command to install the latest ibmdb driver which is compatible with the latest electron version.
Db2: Report an Issue
This option will redirect you to the github page where user can raise issues.
Electron version management is not done by extension. So, If a major electron version is introduced into vs code editor please run Db2: Rebuild Native Modules command to download the latest ibmdb package which is compatible with the latest electron version.
Initial release of Db2Connect
Db2: Report an Issue option to raise an issue.
Db2: Rebuild Native Modules option to handle new electron version release in VS Code editor.
Db2: View Command History option to see the history of command executed by the user.
Db2: Manage Connection Profile from file view to GUI
Please see the usage documentation for more details.