By Kendrick Ren and Eric Radzinski
We'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.
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.
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
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.
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#Db2z/OS#Db2Znews