Release Notes - 3.8
-
3.8.2-funcrel
3.8.2-funcrel
Fixes metamodel error during installation. -
3.8.1-funcrel
3.8.1-funcrel
Fixes missing links and full names of DB2 objects when the SQL file omits the database name and removes false missing objects. Fixes incorrect cyclomatic complexity for SQL Server stored procedures with IF statements lacking END IF. AND and OR are not supported in CAIP 8.3.x analysis. Ignores SAS and Basic Teradata Query files. 📝 59053 Fixes missing link from JPA entity and SQL Table when the schema name contains “-”, e.g. : schema-name. 📝 59132 Excludes built-in Snowflake functions from missing procedures and adds Snowflake system tables as SQL or language system tables. Adds system object types for all system objects created during SQL analysis. System schema/table replaces the previous Missing schema/table when detected as system. These are considered external objects. 3.8.0-funcrel
3.8.0-funcrel
Removes SQL Analyzer contribution from rule 7346 (Avoid redundant indexes), now covered by dedicated rule 1101118 (Avoid redundant indexes (SQL)). Rule 7346 remains active for other technologies. 📝 58134 Fixes traceback error : " AttributeError: ‘Synonym’.type_header_is_wrapped". 📝 57929 Fixes false “Oracle SQL Missing Schema” object when a package with the same name exists. 📝 58385 Fixes false “Oracle SQL Missing Procedure” nodes created for the following built-in functions : INSTRB, LENGTHB, SUBSTRB, LENGTHC, LENGTH2, LENGTH4, SUBSTRC, SUBSTR2, SUBSTR4, INSTRC, INSTR2 and INSTR4. 📝 58387 Fixes false “Missing Stored Procedure” objects from table alias in INSERT queries. 📝 58383 Fixes false “Missing Stored Procedure” objects from Oracle TYPE syntax. 📝 58347 Fixes warnings that occur during the analysis of a DML file. Supports of CREATE TABLE statements in SQL Query objects. Adds new quality 💎 1101118 Avoid redundant indexes (SQL). Removes SQL Analyzer contribution from rule : 7346 Avoid redundant indexes. Improves the naming of missing objects. Improves TCC for SQL Call to Program, SQL Call to Java Method, and SQL Call to C/C++ Function, now set as endpoint/data function only when lacking outgoing links. Improves remediation descriptions for the following quality rules: 1101000 Never use SQL queries with a cartesian product (SQL), 1101002 Never use SQL queries …Improves Remediation descriptions for the following quality rules: 1101000 Never use SQL queries with a cartesian product (SQL), 1101002 Never use SQL queries with a cartesian product on XXL Tables (SQL), 1101004 Avoid non-indexed SQL queries, 1101006 Avoid non-indexed XXL SQL queries, 1101008 Avoid non-SARGable queries, 1101010 Avoid NATURAL JOIN queries, 1101012 Avoid specifying column numbers instead of column names in ORDER BY clauses, 1101014 Avoid queries using old style join convention instead of ANSI-Standard joins (SQL), 1101018 Avoid using the GROUP BY clause, 1101020 Avoid using quoted identifiers, 1101022 Avoid Tables without Primary Key (SQL), 1101024 Avoid using dynamic SQL in SQL Artifacts, 1101026 Always define column names when inserting values, 1101028 Use MINUS or EXCEPT operator instead of NOT EXISTS and NOT IN subqueries, 1101032 Avoid exists and not exists independent clauses (SQL), 1101034 Avoid using DISTINCT in SQL SELECT statements, 1101036 Use ANSI standard operators in SQL WHERE clauses, 1101038 Avoid OR conditions testing equality on the same identifier in SQL WHERE clauses, 1101054 Never use WHEN OTHERS THEN NULL, 1101060 Avoid using LIKE conditions starting with a wildcard character, 1101062 Avoid using multiple statements per line (SQL), 1101072 Avoid not aliased Tables, 1101074 Avoid Tables aliases ending with a numeric suffix, 1101076 Avoid unqualified column references, 1101102 Avoid using LIKE conditions without wildcards, 1101104 Avoid XXL tables without primary key / unique key constraint / unique index, 1101106 Avoid tables without primary key / unique key constraint / unique index, 1101108 Avoid Cobol SQL Cursors without FOR READ ONLY or FOR FETCH ONLY or FOR UPDATE or BROWSE ACCESS clauses, 1101112 Avoid LOCK TABLE statements in SQL code for COBOL Programs Improves performance during linking of DML files. 3.8.0-beta7
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
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
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
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-beta2
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
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.