Introduction

IBM® Db2® for z/OS® Developer Extension is an extension for Microsoft Visual Studio Code that provides language support for Db2 for z/OS SQL, including embedded statements in non-SQL file types such as COBOL, Python, Java, and Node.js.

Db2 Developer Extension modernizes the experience of developing Db2 for z/OS applications by bringing the following key capabilities into one of today’s most popular and widely used development environments:

Basic productivity features:

  • SQL formatting
  • Code completion and signature help
  • Syntax checking and highlighting
  • Customizable code snippet support
  • Integrated support for connecting to Db2 databases
  • Db2 catalog navigation

Features for running SQL:

  • The ability to run selected SQL statements from any type of file
  • The ability to display consolidated results from running multiple SQL statements
  • The ability to select multiple SQL elements on different lines and run those elements as a complete statement
  • The ability to commit or rollback the results of SQL transactions
  • The ability to limit the number of rows in SQL result sets
  • The ability to use null values, validate XML, and retain input values
  • The ability to sort query history by the timestamp of the execution and to quickly identify and display failing SQL statements
  • The ability to run SQL with or without parameter markers and host variables and to save SQL execution results
  • The ability to modify and re-run SQL from the query history

Features for working with native and external SQL stored procedures:

  • The ability to deploy, debug, and run native and external SQL stored procedures
  • The ability to define conditional hit-count breakpoints when debugging native and external SQL stored procedures
  • The ability to run SQL that includes parameters and variables from within native and external SQL stored procedures

Features for working with external Java stored procedures:

  • The ability to deploy and run external Java stored procedures

Features for analyzing and tuning SQL:

  • The ability to analyze and tune SQL by using the extended set of tuning features that are provided with Query Workload Tuner for z/OS 6.1 or by using the base subset of those tuning features that are provided with Database Services Expansion Pack (Visual Explain, Statistics Advisor, and Capture Query Environment). See Software requirements for using the SQL tuning features for more information.
  • Create, migrate, and drop EXPLAIN tables
  • Configure tuning options
  • Save a history of your tuning activities

© Copyright International Business Machines Corporation 2020, 2024.