Release Notes - 3.8

  • 3.8.0-beta7
    Fixes missing XXL table size values on Db2 tables.
    Fixes TCC of the SQL Script Call to Program end points.
    Fixes incorrect call link between a COBOL Program and a Table.
    Improves data-sensitive property values at the table level.
  • 3.8.0-beta6
    Improves the parsing of Oracle PL/SQL files with parameters.
    Adds SQL Call to programs/c/c++functions/java methods objects for SQL External procedures created in system databases / schemas.
    Fixes TCC configuration file issue.
  • 3.8.0-beta5
    Fixes random access links between C# methods and table’s columns.
    Fixes missing violation for the quality rule “Avoid non-indexed SQL queries” on a JDBC SQL Query object.
    Fixes incorrect SQL Missing Table objects created for table’s aliases in DELETE statements.
    Fixes the issue where no database table objects are created from a PostgreSQL file when “AS $$” appears in a casted expression. 📝 56890
    Fixes incorrect missing object created from some JCL SQL Query’s Sqlquery property. 📝 56883
    Fixes the issue where some database objects are not created from a T-SQL file when [Create User XX] appears in a table’s column name. 📝 57125
    Adds ‘SQL Call to Program’ objects for a better linking to external procedures.
    Adds ‘SQL Call to Java Method’ objects for a better linking to external procedures.
    Adds ‘SQL Call to C/C++ Function’ objects for a better linking to external procedures.
    Ignores data-loading SQL files.
    Ignores pf/lf files that are not real DDS files.
  • 3.8.0-beta4
    Fixes missing SQL Synonyms objects. 📝 56558
    Fixes missing link between external Db2 for i SQL procedure implemented in RPG and RPG program when both objects are in the same application.
    Fixes intermittent fluctuation in Missing Table objects between sequential runs.
    Fixes SQL Missing Table objects incorrectly reported for SQL Server temporary tables, and SQL Missing Procedure objects incorrectly reported for EOMONTH and other SQL Server built‑in functions.
    Fixes handling of object names with diacritics in ASCII-encoded files.
    Improves SQL Analyzer link creation performance while enabling RDBMS migration rules and SQL Missing Objects.
    Improves SQL analysis performance when creating links for very large Oracle SQL files. 📝 54904
    Updates SQL analysis to improve performance of the “Create links for file” step on large SQL analysis jobs when RDBMS Data Sensitivity and Column Access is activated.
  • 3.8.0-beta3
    Fixes unanalyzed pkb & pks files. 📝 55469
    Removes incorrect missing procedures and links. 📝 55493
    Fixes slow analysis. 📝 55583
    Removes incorrect temporary objects visible in imaging.
    Fixes incorrect Oracle Method names. 📝 55684
    Removes incorrect missing objects.
  • 3.8.0-beta2
    Fixes incorrect cyclomatic complexity for stored procedure having ELSE IF statement. 📝 55558
    Removes Oracle Forms and Reports incorrect missing procedures and tables. 📝 55493
    Removes incorrect missing procedure named $.
    Removes incorrect missing table and procedures detected in SQL DDL and DML files.
    Fixes missing use link between view and table created from LF and PF files, due to the case difference.
    Fixes SQL-004 warnings during the create links step.
  • 3.8.0-beta1
    Fixes missing use link from view to table due to MySQL syntax issue : SELECT … FROM `table_name``table_name`. 📝 54608
    Fixes performance issue during run extensions at application level. 📝 54723
    Fixes incorrect variant PostgreSQL detected instead of Db2. 📝 55035
    Fixes the missing link between the C/C++ SQL query and a stored procedure called inside an execute immediate.
    Fixes performance issue during the creating link step for an Oracle file when RDBMS Move to Cloud is activated.
    Fixes Db2 stucks during creating links step. 📝 54856
    Fixes missing IBM Db2 for i tables / views.
    Fixes warnings while parsing SQL file. 📝 55362
    PostgreSQL : Fixes missing refer link between tables. 📝 55371
    Oracle : Fixes pkb and pks files unanalysed by the SQL analyser. 📝 55469
    Fixes incorrect missing procedure created for an SQL query: CREATE TABLE table_name().
    DB2: Fixes missing links and properties on homonymous views/tables.
    Adds support for LOAD DATA syntax (JCL DSNUTILB/DSNUTILU SYSIN) as well as LOAD from several RDBMS load utilities..
    Adds support of RDBMS Db2 Data Type Migration rules to Db2 for i (pf/pf files).
    Adds SQL Missing Tables and Procedures for DDL and DML files.