Db2 for z/OS and its ecosystem

 View Only

Announcing IBM Db2 for z/OS Developer Extension 0.5.0

By Eric Radzinski posted Tue October 27, 2020 05:25 PM

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.  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