By Kendrick Ren and Eric RadzinskiWe're pleased to announce that the next iteration of IBM Db2 for z/OS Developer Extension is now available as a free download from the
Visual Studio Code Marketplace.
Building upon the
features that were delivered in its initial release, Db2 Developer Extension 0.5.0 continues to evolve by providing additional capabilities that make it easier for developers to write applications that interact with Db2 for z/OS data.
Here's a quick rundown of the new features available in release 0.5.0:
Adding a database connection
The ability to create connections to Db2 for z/OS databases has been integrated into Db2 Developer Extension through the addition of an
Add connection wizard. Prior to 0.5.0, developers were unable to connect to Db2 for z/OS from the extension. See
Creating a database connection for more information.
SQL execution
You can now run your SQL directly from Db2 Developer Extension. You can run individual SQL statements that you highlight or all of the SQL statements in a file by right-clicking and selecting
Run Selected or
Run All respectively. You can run SQL with or without parameter markers and host variables, and you can save your SQL execution results in a .csv file. You can also specify run options to control how your SQL is parsed and run. See
Running multiple SQL statements for more information.
Syntax checking
Syntax checking automatically recognizes and underlines SQL elements that have been specified incorrectly. It also provides the valid expected replacement when you hover over an incorrectly specified element or when you display it in the
PROBLEMS view. See
Getting started with Db2 Developer Extension for more information.
Code completion and signature help
Code completion simplifies the process of writing SQL statements by suggesting valid completions as you type, which helps both new and experienced developers write SQL statements more quickly and efficiently. Signature help provides information about the parameters that are required by a function or procedure to help ensure that your SQL statements are complete and valid. For this release, these two features are provided for Db2 built-in functions and stored procedures. See
Getting started with Db2 Developer Extension for more information.
Tell us what you think!
Give the new release of Db2 Developer Extension a test drive and let us know what you think. You can submit feedback by opening an
issue in our GitHub repository or by submitting review comments in the
Visual Studio Code Marketplace.
Kendrick Ren is the IBM Db2 for z/OS Developer Extension Technical Lead, and Eric Radzinski is an Information Developer for Db2 for z/OS.
Sign in and subscribe to always get the latest news about Db2 for z/OS from the IBM lab: http://ibm.biz/db2znews-subscribe#Db2forz/OS#db2z/os#Db2Znews