Releases: IBM/db2forzosdeveloperextension-about
Releases · IBM/db2forzosdeveloperextension-about
v2.2.4
- Added support for IBM Db2 CI/CD Expert for z/OS.
- Added support for XML schemas in catalog navigation.
- Added support for calling stored procedures and user-defined functions for all supported languages from catalog navigation.
- Added support for explicit commit or rollback based on the impact of SQL changes through the use of a new "Run SQL Impact" context menu option in the editor tab.
- Added support for deploying stored procedures and user-defined functions for SQL language from catalog navigation.
- Added support for remote certification when tuning without a profile.
- Improved the view of DDL tab in catalog navigation to include line numbers.
- Improved the behavior of the SQL Results view in situations where the All option is enabled in the items per page dropdown for full data display.
- Fixed a situation in which tuning profile options were displayed in the tuning Connections view when the Tuning Services server option is set to NONE.
- Fixed an issue in which tuning profiles are not retrieved while attempting to tune with no tuning profile selected.
- Fixed an issue in which the Search functionality for the Package - Statement view and the UDF - Parameters view in catalog navigation was returning incorrect results.
- Resolved various security vulnerabilities.
v2.2.3
- Added support for canceling a long-running or unresponsive SQL process.
- Added support for using multi-factor authentication (MFA) to tune SQL queries without specifying a password.
- Added support for loading, saving, and resetting host variables for stored procedures and user-defined functions from the catalog view or from a file.
- Improved the results of running a stored procedure from the SQL editor by using a CALL statement by accurately classifying input and output parameters.
- Fixed the behavior of database connections that use security mechanism 18 so that users are no longer prompted for a password when using those connections.
- Fixed an issue in stored procedure deployment with duplicate handling.
- Fixed an issue in which the position of OUT variables was mapped incorrectly.
- Fixed an issue in which alternating between two connections prevented the use of special registers and global variables.
- Fixed an issue with displaying DDL for External SQL stored procedures during catalog navigation.
- Resolved various security vulnerabilities.
v2.2.2
- Fixed an issue with keytar that prevented Db2 Developer Extension 2.2.1 from opening from VS Code 1.100.
- Addressed an issue in which the user ID and password for a Db2 connection is not available when the connection is shared for the first time. When this situation occurs, you are now prompted to re-enter your user ID and password for that connection.
V2.2.1
- Added support for running and debugging user-defined functions (UDFs).
- Added support for deploying a combination of stored procedures and user-defined functions (UDFs) in a single operation.
- Added support for controlling processing behaviour if an error occurs when multiple routines are deployed simultaneously.
- Added support for activating a new version of a native stored procedure or compiled UDF from catalog navigation.
- Added support for calling a native or external SQL stored procedure from catalog navigation.
- Added support for specifying package collection IDs when running tuning actions through the implementation of the currentPackagePath property.
- Documented a fix for truncated trailing zeros in the timestamp column of query results and table data.
- Improved table data editing by adding support for editing DISTINCT data types.
- Improved table data editing by including the length value in column headings.
- Fixed an issue that caused VS Code to open slowly.
- Fixed an issue in which incorrect data was exported when clicking Save results in the SQL Results view.
- Fixed an issue in which an errant error message was issued when the extension was opened.
- Resolved various security vulnerabilities.
v2.2.0
- Added support for deploying multiple stored procedures in a single operation.
- Added support for deploying user-defined functions.
- Added support for deploying SQLJ stored procedures.
- Added support for debugging Java and SQLJ stored procedures.
- Added support for table data editing.
- Added support for generating DDL for databases, tables, table spaces, indexes, and views.
- Added support for MFA, PassTicket in debugger, and tuning without a profile.
- Added support for filtering certain columns in catalog navigation by blank values for databases, plans, packages, stored procedures, triggers and user-defined functions.
- Improved performance of viewing catalog navigation objects.
- Improved Add/Edit connection view by enabling the Finish button when the password field is empty, which allows users to save changes without entering a password.
- Improved the Edit Connection view by allowing users to disassociate a tuning connection.
- Fixed an issue with the Connection view to ensure that newly created tuning profiles are associated with the correct Db2 connection when the user chooses to define this association.
- Fixed an issue with DDL truncation in DDL tab across catalog navigation.
- Fixed an issue with debugging a stored procedure in which an extra editor opens when debugging is restarted.
- Fixed an issue with filtering the catalog navigation plan in which filtering values with Match Any.
- Fixed an issue with importing Db2 connections from IBM Data Studio.
- Fixed an issue with deploying native stored procedure to use the configured target schema as current schema.
- Resolved various security vulnerabilities.
v2.1.7
- Fixed an issue with importing Db2 connections from IBM Data Studio.
- Fixed an issue that prevented users from running tuning actions after upgrading to Db2 Developer Extension 2.1.6.
- Fixed an issue that prevented users from using security mechanisms 7 and 9 when running tuning actions.
v2.1.6
- Added support for importing Db2 database connections from IBM Data Studio.
- Added support for debugging external stored procedures.
- Added support for creating a tuning profile from the Tuning tab when creating a Db2 connection.
- Added support for selecting multiple Java dependencies simultaneously when deploying Java stored procedures.
- Added support for filtering by all columns across catalog navigation.
- Added support for filtering by same column multiple times.
- Added support to display full text for LOB/CLOB data types.
- Improved performance of viewing catalog navigation objects.
- Fixed an issue with Running SQL where duplicate host variables were displayed multiple times.
- Fixed an issue with executing SQL in notebook editor where link was broken for scrollable element in SQL result output.
- Fixed an issue with executing SQL in notebook editor when the Notebook > Output: Text Line Limit setting is changed, the number of SQL result output lines doesn't change.
- Fixed an issue with native stored procedure where removing ASUTIME from routine options results in message not parsed.
v2.1.5
- Added support for deploying external SQL and Java stored procedures.
- Added support for executing SQL in notebook interface.
- Added support for viewing the extension in light color theme.
- Added support for filtering catalog navigation objects by all columns for databases, indexes, storage groups, stored procedures, and tables.
- Added support for displaying Java source and JAR dependencies of Java stored procedure catalog navigation objects.
- Added support for additional routine code snippets.
- Added support for displaying the Db2 subsystem location in the TUNING HISTORY view.
- Fixed an issue with connecting to Db2 connections using SSL client certificates where user ID and password were required.
- Fixed an issue with catalog navigation package objects for REST services not retrieving statements.
- Fixed an issue with catalog navigation external SQL stored procedure objects not retrieving DDL.
- Fixed an issue with
!!and^=not being formatted correctly. - Formatted SQL statements shown in catalog navigation.
- Removed hard requirement for 64-bit Java JRE.
- Resolved various security vulnerabilities.
- Upgraded the IBM Data Server Driver for JDBC and SQLJ to version 4.32.28 to resolve Log4j vulnerability.
v2.1.4
- Added support for catalog navigation with global variables and REST services.
- Added support to not save the password for SQL Tuning Services servers (#114).
- Fixed an issue for catalog navigation when browsing stored procedures with periods in the version (#116)
- Fixed an issue for catalog navigation when browsing sequences for identity columns and implicitly created DOCID columns.
- Fixed an issue when a connection could not be retrieved when using catalog navigation after debugging a native stored procedure.
- Formatted DDL shown in catalog navigation.
- Enhanced error messages related to EXPLAIN tables when tuning SQL.
- Resolved various security vulnerabilities.
