Release Notes - 3.7

---

3.7.21-funcrel

Fixes/Bugs

Customer Ticket Id	Customer Details
	Fixes handling of object names with diacritics in ASCII-encoded files.
	Fixes intermittent fluctuation in Missing Table objects between sequential runs.

3.7.20-funcrel

Fixes/Bugs

Customer Ticket Id	Customer Details
	Removes incorrect missing objects.
55684	Fixes incorrect Oracle Method names.
	Removes incorrect temporary objects visible in imaging.
55583	Fixes slow analysis.
55493	Removes incorrect missing procedures and links.
55469	Fixes unanalyzed pkb & pks files.

3.7.19-funcrel

Fixes/Bugs

Customer Ticket Id	Customer Details
55371	PostgreSQL : Fixes missing refer link between tables.
	Fixes missing use select link between stored procedure and table.
55469	Oracle : Fixes pkb and pks files unanalysed by the SQL analyser.
	Fixes SQL-004 warnings during the create links step.
	Fixes missing use link between view and table created from LF and PF files, due to the case difference.
	Removes incorrect missing table and procedures.
	Removes incorrect missing procedure named $.
55493	Removes Oracle incorrect missing procedures and tables.
55558	Fixes incorrect cyclomatic complexity for stored procedure having ELSE IF statement.

3.7.18-funcrel

Fixes/Bugs

Customer Ticket Id	Customer Details
55362	Fixes warnings while parsing SQL file.
	Fixes missing IBM Db2 for i tables / views.
54856	Fixes Db2 stucks during creating links step.
	Fixes performance issue during the creating link step for an Oracle file when RDBMS Move to Cloud is activated.
	Fixes the missing link between the C/C++ SQL query and a stored procedure called inside an execute immediate.
55035	Fixes incorrect variant PostgreSQL detected instead of Db2.
54608	Fixes performance issue during run extensions at application level.
54608	Fixes missing use link from view to table due to MySQL syntax issue : SELECT … FROM `table_name``table_name`.

3.7.17-funcrel

New Support

Customer Ticket Id	Customer Details
	Adds support for SQL Server to Azure SQL migration path.

3.7.16-funcrel

Fixes/Bugs

Customer Ticket Id	Customer Details
54359	Fixes the wrong link between an Entity Operation and a SQL table.
	Adds extra spaces in the column data type property when needed.
	Fixes missing schema named DEFAULT.
53690	Fixes missing link between procedure and table.
53913	Fixes false "missing tables".
	Fixes SQL-004 warnings.
53914	Removes false "missing procedure" which is in fact an alias used in several MERGE queries.
	Fixes End Migrate Oracle Projects for the application Application with exception: 'NoneType' object is not iterable.

Performance

Customer Ticket Id	Customer Details
54102	Fixes SQL analyzer performance issue during link phase.
	Fixes performance issue during SQL Server linking.
	Fixes performance issue during Oracle linking.

3.7.15-funcrel

Fixes/Bugs

Customer Ticket Id	Customer Details
	Removes pympler.
	Fixes missing links.
	Fixes .sql file not analyzed when, from the total number of DML statements, 81.82% are INSERT in a context of Db2 for i analysis.
	Fixes incorrect variant detection.

New Support

Customer Ticket Id	Customer Details
	Adds data type and column length property to the table's column declared in .pf/.lf files.
	Adds support of the FORMAT keyword in .pf/.lf files. It will bring the columns to these tables and views.

3.7.14-funcrel

Fixes/Bugs

Customer Ticket Id	Customer Details
53629	Fixes missing links to synonyms from SQL objects when links are created to referenced table.
	Fixes linking performances for packages.
	Fixes missing Use Insert link for incorrect SQL Query statement : INSERT <TABLE_NAME>.
	Removes incorrect missing table.
53445	Fixes wrong database type discovered by SQL analyzer.

New Support

Customer Ticket Id	Customer Details
	Adds support for SQL Server to Azure SQL migration path.

3.7.13-funcrel

Fixes/Bugs

Customer Ticket Id	Customer Details
52477	Fixes merged primary keys that do not have the same SQL variant.
52371	Fixes missing call link from shell script to SQL stored procedure.
	Fixes Engineering Dashboard visibility for all RDBMS Move to Cloud migration rules.

New Support

Customer Ticket Id	Customer Details
	Adds support of the system names for Db2 for i views, indexes and columns : https://www.ibm.com/docs/en/i/7.4.0?topic=statements-create-view , https://www.ibm.com/docs/en/i/7.4.0?topic=statements-create-index , https://www.ibm.com/docs/en/i/7.4.0?topic=statements-create-table .

3.7.12-funcrel

Fixes/Bugs

Customer Ticket Id	Customer Details
52387	Fixes missing function and trigger objects.
	Fixes GUID migration error when using Core 8.4.x.
	Fixes incorrect missing .NET procedure objects created when T-SQL stored procedures already exist.
	Fixes a missing reylon link between synonyms and table objects.
	Fixes incorrect name of a missing procedure object.
	Fixes incorrect missing table object.
52747	Fixes incorrect access write links.
52511	Fixes incorrect links between stored procedures and tables, that do not have the same SQL variant.
52477	Fixes merged tables and indexes that do not have the same SQL variant.

New Support

Customer Ticket Id	Customer Details
52298	Db2 for i: Added support for system names for tables : https://www.ibm.com/docs/en/i/7.4.0?topic=statements-create-table .
	Added Use Select links between cursor embedded in RPG code (FETCH cursor_name) and selected tables (in DECLARE cursor_name).
	Added support for Db2 to SQL Server migration path for com.castsoftware.sql.movetocloud extension.
	Added support for Db2 to Oracle migration path for com.castsoftware.sql.movetocloud extension.
	Added support for SQL external procedure/function. The following languages are supported : COBOL, COBOLLE, RPGLE, RPG, CL, C, C++, JAVA, ASSEMBLE, PLI, REXX.

3.7.11-funcrel

Resolved Issues

Customer Ticket Id	Details
52048	Fixed missing links from Functions to Tables, when strings with dynamic SQL code are not executed. E.g. : sql_statement = 'select * from table_name' return sql_statement.
51936	Fixes an issue (due to table duplication) preventing table objects from being created even when the correct DDL scripts are delivered.

Other Updates

Details
Oracle: added missing "relyon" link between Function / Procedure and Table / Type when variables are declared as "%ROWTYPE" or "%TYPE".
Fixed incorrect "missing table" object created when a Cassandra table exists.

New Support

Summary	Details
MySQL: Add support fore executable comments	Added support for CREATE statements in comments (executable comments).

3.7.10-funcrel

Resolved Issues

Customer Ticket Id	Details
51613	DB2 : fixed incorrect merge of table having the same name, created in the schemas having the same name but in different databases. Added the database name in the full identifier of views and indexes, when the view / index are created in the same file with table, just after the CREATE TABLE statement.
51180	Oracle : fixed traceback raised by SQL Analyzer during analysis.
51524	MySQL: Added support of the DEFINER clause in the CREATE TRIGGER statement.

Other Updates

Details
Fixed traceback warning during CREATE FUNCTION statement analysis.
Fixed missing use link between a SQL Query and a DEFAULT.table_name when the schema name cannot be resolved and the table is accessed via a SCHEMA_NAME (SCHEMA_NAME.TABLE_NAME).
Fixed unexpected Missing Table SCHEMA_NAME.TABLE_NAME created when a DEFAULT.TABLE_NAME already exists.
Oracle USING INDEX TABLESPACE storage clause should not create a SQL Index named TABLESPACE.

Rules

Rule Id	New Rule	Details
1101062	FALSE	Added support for Oracle Forms and Reports objects.
1101024	FALSE	Added support for Oracle Forms and Reports objects.
1101052	FALSE	Added support for Oracle Forms and Reports objects.
1101054	FALSE	Added support for Oracle Forms and Reports objects. Fixed typo in the rule name WHEN OTHER replaces with WHEN OTHERS.
1101064	FALSE	Added support for Oracle Forms and Reports objects.
1101030	FALSE	Added support for Oracle Forms and Reports objects.
1101074	FALSE	Added support for Oracle Forms and Reports objects.
1101072	FALSE	Added support for Oracle Forms and Reports objects.
1101076	FALSE	Added support for Oracle Forms and Reports objects.
1101012	FALSE	Added support for Oracle Forms and Reports objects.
1101028	FALSE	Added support for Oracle Forms and Reports objects.
1101008	FALSE	Added support for Oracle Forms and Reports objects.
1101086	FALSE	Added support for Oracle Forms and Reports objects.
1101002	FALSE	Added support for Oracle Forms and Reports objects.
1101016	FALSE	Added support for Oracle Forms and Reports objects.
1101084	FALSE	Added support for Oracle Forms and Reports objects.
1101018	FALSE	Added support for Oracle Forms and Reports objects.
1101098	FALSE	Added support for Oracle Forms and Reports objects.
1101034	FALSE	Added support for Oracle Forms and Reports objects.
1101000	FALSE	Added support for Oracle Forms and Reports objects.
1101030	FALSE	Added support for Oracle Forms and Reports objects.
1101004	FALSE	Added support for Oracle Forms and Reports objects.
1101006	FALSE	Added support for Oracle Forms and Reports objects.
1101014	FALSE	Added support for Oracle Forms and Reports objects.
1101114	FALSE	Added support for Oracle Forms and Reports objects.
1101058	FALSE	Added support for Oracle Forms and Reports objects.
1101066	FALSE	Added support for Oracle Forms and Reports objects.
1101116	TRUE	Replaced 7424 Avoid using SQL queries inside a loop with a new one 1101116 Avoid using SQL queries inside a loop (SQL). The rule is also applying to Oracle Forms and Reports objects.

New Support

Summary	Details
Added support of linking and quality rules for Oracle Forms and Reports objects.	Oracle Forms and Reports objects, created by com.castsoftware.formsreport, are from now linked by SQL Analyzer. SQL quality rules are also calculated during the step "Run extensions after analysis".
Declared SQL Missing procedure as transaction end point.	In order to ensure transactions are valid and reach their end point.
Declared SQL procedures, functions, views and DML scripts as end points.	This ensures transactions are valid and reach their end points.

Performance

Summary
Improved performances for Oracle package's analysis during the create links step.

3.7.9-funcrel

Resolved Issues

Customer Ticket Id	Details
50787	Fixed missing links between Db2 views and Db2 tables.
50131	Fixed unexpected missing table when the table name is a parameter. E.g. : select * from ${dbschema}.${tableId}.
50494	Oracle: fixed missing links between PL/SQL stored procedures with same name when they belong to different packages.
50410	Fixes an issue causing the "run extension" step to fail at application level during the analysis.

Other Updates

Details
DB2 : fixed incorrect Unique Key Constraint named LABEL created when key label is specified at the table level for encryption (KEY LABEL key-label-name or NO KEY LABEL). Merge duplicate tables, having the same create statement, in different SQL files.
Fixed traceback raised by SQL Analyzer, for a Java Hibernate SQL Query "update from…".
Fixed too many warnings SQL-001: No schema found, while the uaxdirectory seems to have the schema referenced.
Fixed missing table ( .net) named Release is not created.
Fixed missing Sensitive Data Option in V3 Imaging.

Rules

Rule Id	New Rule	Details
7424	FALSE	Fixed false positive violations for the rule "Avoid using SQL queries inside a loop" when analyzing Microsoft SQL Server source code.
1101038	FALSE	Fixed false positive violations for the rule "Avoid OR conditions testing equality on the same identifier in SQL WHERE clauses" when the OR conditions are in different parentheses.

New Support

Summary	Details
Update vendor compatibility	Support has been added for various RDBMS: Microsoft SQL Server 2022, Oracle Server 21c and 23ai, PostgreSQL 17.x and CockroachDB 24. See also: Vendor compatibility matrix - official support.

3.7.8-funcrel

Resolved Issues

Customer Ticket Id	Details
49971	Fixes an issue causing a missing link from Cobol SQL Query objects to Table through Synonym objects.
50345	Fixes an issue causing a missing link from Cobol SQL Query objects to Oracle function objects.
49703	Fixes an issue in the file "migrate_sql_project_name_in_guid.sql" causing the extension installation step to hang.

Other Updates

Details
Updated the documentation to improve information about the links generated by the analyzer, see: https://doc.castsoftware.com/technologies/sql/extensions/com.castsoftware.sqlanalyzer/3.7/#links .
Added more information to the analysis log, specifically during the Inference Engine Queries loading step.
Fixes an issue causing the creation of strange/not meaningful missing procedures named "{}?{}, {}'{}'{}".
Fixes an issue causing traceback warnings and duplicate GUIDs when analyzing Sybase ASE SQL files.
Fixes an issue causing the the analyzer to detect the incorrect RDBMS Vendor type: DB2 for I instead of Oracle.
Fixes an issue causing missing links between Entity Operations / SQL Queries and Synonyms / aliased objects.

3.7.7-funcrel

Resolved Issues

Customer Ticket Id	Details
49437	Fixes an issue causing the analyzer to fail to find the end of a SQL Server stored procedure containing XML tags in string expressions, in turn causing the remaining code in the relevant file to be analyzed as if it were part of the procedure.
49560	Fixes an issue causing a false positive violation of the rule 1101000 "Never use SQL queries with a cartesian product (SQL)" for SAP Method SQL Script Functions containing a JOIN which uses the table name as a parameter, e.g. : table_name1 join :parameter_name.

Other Updates

Details
Fixes an issue causing the wrong vendor type to be detected on a Cobol file with .SQL as its extension.
Improved the detection of Oracle variant.
The description of the object "SAP Method SQLScript Procedure" has been changed to "ABAP Managed Database Procedure".

Rules

Rule Id	New Rule	Details
1101000	FALSE	Fixes an issue causing a false positive violation of the rule 1101000 "Never use SQL queries with a cartesian product (SQL)" for SAP Method SQL Script Functions containing a JOIN which uses the table name as a parameter, e.g. : table_name1 join :parameter_name.

New Support

Summary	Details
SQLSCRIPT-1385	Missing tables and procedures objects generated by this extension have been changed from the "external" to "internal" object type category. As a result of this change, objects are now visible in the Transactions > Data Entities section in CAST Imaging/Console, and in addition, where an existing application with unchanged source code is re-analyzed with this new release, the number of Data Function Points will increase.
SQLSCRIPT-1386	Added support for Missing Tables and Procedures for Java JSP projects in the com.castsoftware.jee.missingtable extension.

3.7.6-funcrel

Resolved Issues

Customer Ticket Id	Details
48868	Fixes an issue causing missing links between CRUD Entity and Table.
49253	IBM for i related: Fixes a missing table issue when the table is prefixed by a schema starting with "&", e.g. : "CREATE TABLE &VAR/OTTO (COL1 INT, …);".
49242	IBM for i related: Fixes a false Cyclomatic Complexity value for Views based on "lf" files.
49250	Mainframe related analyses: Fixes an issue causing the analysis to hang during the "run extension after analysis step, within the stage "Start calculating client server quality rules".

Other Updates

Details
Minor update to add code "bookmarks" for monitor links.
Fixes an issue causing a runtime error at application level for a CTLProgram object.
Fixes an issue causing the generation of an incorrect Missing Procedure object.
Mainframe XXXL application: Fixes a performance issue during the application level step, impacting the calculation of client server quality rules.
XXXL Mainframe application: Fixes a performance issue during the application level step for SQL Analyzer. Removed unuseful logged messages.

3.7.5-funcrel

Resolved Issues

Customer Ticket Id	Details
48461	Fixed false links from SpringData Query to Tables.

Other Updates

Details
Fixed a performance issue in the post-application step pushing links from synonyms to aliased objects for Mainframe applications.
Fixed an issue causing the property "Raw SQL Complexity" to not be generated for Java Methods.
Fixed error during application level at the step "adding missing links between SQL embedded queries and SQL Tables / Views / Procedures / Functions".
Fixed duplicated tables when create statements are similar.
Fixed performance issue during application level at the step "removing UA select all properties for SQL Analyzer Objects and objects from languages having SQL Named Queries objects".
Fixed Oracle built-in functions wm_concat, LISTAGG and NUMTODSINTERVAL reported as Missing Procedure.
Fixed issue with PostgresSQL tables identified as DB2 / Oracle tables.

3.7.4-funcrel

Resolved Issues

Customer Ticket Id	Details
48078	PostgreSQL: fixed missing SQL objects due to a misinterpreted regular expression.

Other Updates

Details
Fixed an issue causing SQL files to be ignored (visible in com.castsoftware.sqlanalyzer 3.6.19).
PostgreSQL: fixed built-in functions which are created as missing procedure / table objects.
Fixed LF and PF files analyzed in RPG and SQL Analyzer.
Cobol SQL Query: fixed a missing link to a table column object.
Fixed SQL-002 warning raised by a "CREATE INDEX" statement with a column named "KEY" in the list of indexed columns. E.g. : "CREATE INDEX index_name ON table_name (column_name, KEY)".
Fixed Missing Table not created when the table belongs to system schema.

Rules

Rule Id	New Rule	Details
1101090	FALSE	Fixed an issue causing false positive violations when the clustered index is added in the same alter table statements with a default constraint, in the second position. E.g.: "ALTER TABLE table_name ADD CONSTRAINT default_name DEFAULT (default_value) FOR column_name, CONSTRAINT pk_name PRIMARY KEY (list_of_the_columns) CLUSTERED".
1101022	FALSE	Fixed an issue causing false positive violations when the primary key is added in the same alter table statements with a default constraint, in the second position. E.g.: "ALTER TABLE table_name ADD CONSTRAINT default_name DEFAULT (default_value) FOR column_name, CONSTRAINT pk_name PRIMARY KEY (list_of_the_columns)."
1101114	TRUE	Added a new rule named Avoid "SELECT *" queries (SQL) which replaces the rule 7344: Avoid "SELECT *" queries for the SQL objects and also for the SQL Query objects. This quality rule reports the SQL artifacts containing queries using the "SELECT *" statement. It applies to DDL as well as DML, including embedded SQL in client code when materialized by a SQL Query object. Not all "SELECT *" queries are reported in violation, some of them are ignored. E.g.: SELECT * FROM a single table in VIEWs / MATERIALIZED VIEWs, CREATE TABLE AS SELECT * FROM a single table, SELECT * INTO table_name FROM a single table, EXISTS(SELECT *, NOT EXISTS(SELECT *, SELECT * EXCEPT(…).

New Support

Summary	Details
SQLSCRIPT-1339	When PostgreSQL objects are created without specifying any schema name, by default such objects are automatically put into a schema named "public". From now on, "public" will be considered by com.castsoftware.sqlanalyzer as the DEFAULT schema for PostgreSQL objects.
SQLSCRIPT-1338	Added a specific property named "System object" for any SQL system objects detected.
SQLSCRIPT-1325	Added Raw SQL Complexity Metric for SQL Query objects.

3.7.3-funcrel

Resolved Issues

Customer Ticket Id	Details
47857	Fixed incorrect link to a table which has same name but different parent schema to the one referenced in the Dapper SQL Query object.
47746	Added support for CREATE EXTERNAL TABLE statement.

Other Updates

Details
Fixed WARNING during run extensions after analysis when adding missing links between SQL embedded queries and SQL objects.
Fixed missing links between JPA Query and JPA Entity Operation and SQL Tables.
Fixed missing useSelect link between FETCH Cobol Query and Table.
Fixed ValueError: invalid literal for int() with base 10: '100000 00270000' during table's size loading.

3.7.2-funcrel

Other Updates

Details
Fixed missing links between JPQL Query and SQL Table objects.
Fixed a WARNING occurring during the run extension step after an analysis, for Mainframe applications.

3.7.1-funcrel

Resolved Issues

Customer Ticket Id	Details
46591	Fixed missing links between SQL Query objects and Table objects due to a crash at the application level.
46682	Fixed incorrect links created from procedure to a table named SET (MERGE INTO… UPDATE SET syntax).
47343	Oracle: Some SQL files, with data export / loading statements, were previously and incorrectly considered as DML. This has now been fixed.

Other Updates

Details
Fixed invalid Missing Procedure object when a Package Procedure with the same name also exists.
Fixed an issue causing a SQL Missing table object to not be created and a duplicate GUID message to be logged in the application level file.
Fixed RuntimeError ("Cannot use Object.get_property() if property has not been loaded").
Oracle: improved the process of merging duplicate objects.
Rules for Cobol SQL Embedded Query objects: removed Cobol file parsing at application level. To benefit from this fix, you should use at least the version 1.1.0-funcrel of com.castsoftware.mainframe.
Oracle : Fixed SQL-004 warning.
Fixed and removed duplicated objects.
Fixed multiple "AttributeError" issues found in in com.castsoftware.sqlanalyzer 3.6.11-funcrel.

Rules

Rule Id	New Rule	Details
1101008	FALSE	T-SQL: fixed false positives for the rule "Avoid non-SARGable queries" when a SELECT is used in dynamic SQL.
1101000	FALSE	T-SQL: fixed false positives for the rule "Never use SQL queries with a cartesian product (SQL)" when a SELECT is used in dynamic SQL.
1101004	FALSE	Fixed a random missing violation for the rule "Avoid non-indexed SQL queries".
1101026	FALSE	T-SQL: fixed false positives for the rule "Always define column names when inserting values" when WITH tables hints are used.

3.7.0-funcrel

Resolved Issues

Customer Ticket Id	Details
46125	Fixed missing links between Cobol SQL Query and Tables.
45659	Fixed tables columns reported as missing procedures.
45635	Fixes an issue where the analysis became stuck after the "DssRun" step finished successfully.
45553	Fixes an issue causing SQL-004 warnings for 5 files during link creation phase for an Oracle analysis.

Other Updates

Details
Improved application level performance.
Fixed duplicated synonyms.
DotNet Enterprise Library SQL Query object: fixed an issue causing a missing Procedure.
Fixed duplicated tables.
CTLCode objects: fixed missing links between CTLCode and SQL Table objects when the name of the table is PRINT.
Spring JDBC Query obejcts: fixed missing links for tables that have the same name.
JDBC SQL Query objects: fixed incorrectly created Missing table object for CREATE TABLE statements.
Oracle PL/SQL scripts: a change has been implemented to ensure that a BEGIN in a PROMPT statement is no longer considered the beginning of a block statement.
Fixed missing links between JPQL Query and SQL Tables.
Cobol SQL Query object: fixed missing links when FETCH is used with NEXT ROWSET.
Removed SQL Analyzer log messages from analysis units that are not SQL related.
Fixes an issue where some objects (Synonyms, Missing Tables) were incorrectly set as "end points" isntead of "data entities" for transaction purposes.

Rules

Rule Id	New Rule	Details
1101026	FALSE	Fixed false positive violation which was occurring when the table's schema name is a parameter.

New Support

Summary	Details
Support fo IMS linking	Added support for the linking between IMS SQL Query objects and IMS DB Segment objects. Available with com.castsoftware.mainframe >= 1.4.0-alpha1 and com.castsoftware.wbslinker >= 1.7.33.
Support for missing tables for Entity Operations	Added the support for missing tables for Entity ORM CRUD operations. You should install com.castsoftware.sqlanalyzer >= 3.7.0-funcrel if you have Entity Operations in your applications and you are already using com.castsoftware.entity >= 2.2.12-funcrel.

3.7.0-beta5

Resolved Issues

Customer Ticket Id	Details
44556	Improved links for SQL DML files: DML files are now considered as data exports only when INSERTs have static data.
41969	Fixes an issue causing missing "belongs to" links.
40693	Fixed false positive on the rule 1101106 "Avoid tables without primary key / unique key constraint / unique index".

Other Updates

Details
Fixed application level error.
Fixed missing insert link from Spring JDBC Query to SQL Table.
Fixed SQL-002 parsing issue raised on ALTER TABLE … RENAME statement.
Improved detection of DATA exports vs DML files.

Rules

Rule Id	New Rule	Details
1101106	FALSE	Fixed false positives for the rule "Avoid tables without primary key / unique key constraint / unique index".

New Support

Summary	Details
Link ORM CRUD Operations with SQL Tables/Views	Moved the linking of ORM CRUD Operations with SQL Tables/Views from Universal Linker (com.castsoftware.wbslinker) to SQL Analyzer.
Support for missing tables	Added support for missing tables for .NET/JEE ORM CRUD operations.
ORACLE : Object Types : added new link between methods	Added inheritOverrideLink from a Method's Type which overrides a super Type's Method.
ORACLE : Object Types : changed link type from sub Type to super Type	The link inheritLink has been changed to inheritExtendLink.
ORACLE : Object Types : added relyon link for parameters/variables datatypes	Added relyonLink from Type's Method to another Type/Table when parameters/variables datatypes are Type/Table Columns.
ORACLE : Object Types : added call link for indirect calls	Added callLink from a Method's Type via another Method's Type when an object's method is called indirectly, via a variable.

3.7.0-beta4

Resolved Issues

Customer Ticket Id	Details
42424	Fixed false link between SQL Server Procedures and Db2 Tables.
44915	Fixed an issue causing the error "ERROR: negative substring length not allowed."
44816	Fixed incorrect missing table object "LOCKS" created for SQL statement "USE AND KEEP UPDATE LOCKS".

Other Updates

Details
Fixed Invalid name assigned to artifact when %SCHEMA% prefix is used in SQL script. E.g. : "CREATE PROCEDURE %SCHEMA%.TOTO" … previous to the fix the SQL Procedure was named "%" and now the name is "TOTO".
When two missing objects with same name are created one in DEFAULT the second in a named missing schema - because the object is prefixed - the one in the DEFAULT schema should be merged in the second one, from the named schema. E.g.: for the following SQL Embedded Queries: "select * from TOTO.TATA and "select * from TATA" a single Missing Table will be created : "TOTO.TATA.TATA".
Changed SQL Analysis objects GUID’s. The analysis unit name logged in the analysis log will no longer contain the numeric suffix. Eg.: a previous GUID "SQLScriptFunction?Main_sourcesDatabase_36645.CASTPUBS.STORENAME_PROC" will change to "SQLScriptFunction?Main_sourcesDatabase.CASTPUBS.STORENAME_PROC". During the update to the new version, all SQL Analyzer GUID’s will be migrated.

Rules

Rule Id	New Rule	Details
1101090	FALSE	Fixed false positives for "Avoid Tables without a clustered Index (SQL)".
1101024	FALSE	Fixed false negatives for "Avoid using dynamic SQL in SQL Artifacts".
1101102	FALSE	Fixed false negatives for "Avoid using LIKE conditions without wildcards".
1101008	FALSE	Fixed false positives / negatives for "Avoid non-SARGable queries".

3.7.0-beta3

Resolved Issues

Customer Ticket Id	Details
43979	Fixed Trigger and Index fullnames when only the table name is prefixed.

Other Updates

Details
Fixed false link between a procedure and a table, when table is not in the procedure scope.
Fixed random metric inconsistency for metric "Max Control Statements Nested" for duplicated objects, created in different SQL files.

New Support

Summary	Details
Add support for the Teradata statement DATABASE <DATABASE_NAME>;	The default session database is correctly detected.

3.7.0-beta2

Other Updates

Details
Fixes an issue causing the creation of a "SQL Missing Table" object when a standard SQL table obejct with the same name already exists.

Rules

Rule Id	New Rule	Details
1101076	FALSE	Fixed a missing violation for the rule 1101076 "Avoid unqualified column references".
1101008	FALSE	Fixed a false positive violation on the rule 1101008 "Avoid non-SARGable queries".
1101006	FALSE	Fixed a false positive violation on the rule 1101006 "Avoid non-indexed XXL SQL queries".

New Support

Summary	Details
New advisor: Migrate DB2 to MySQL	Added support for "Migrate DB2 to MySQL" advisor rules in com.castsoftware.sql.movetocloud extension.

3.7.0-beta1

Resolved Issues

Customer Ticket Id	Details
43519	Fixed missing Oracle procedure and package objects when the SQL file is considered as DML instead of DDL.

Other Updates

Details
Fixed SQL-002 analysis warning for ALTER TABLE statements.

Rules

Rule Id	New Rule	Details
1101006	FALSE	Removed false positives when the table is filtered via a CASE statement. And also in the situation when multiple tables with the same name are matching for the selected table.

New Support

Summary	Details
Added the support for new SQL file extensions.	More file extensions are supported. You can find all details in the official documentation https://doc.castsoftware.com/display/TECHNOS/SQL+Analyzer+-+3.7#SQLAnalyzer3.7-Supportedfileextensions .