AMT 161
Released: 26 Sep 2025.
For availability, please contact the Avanade Service Portal for information on downloading new releases.
Special attention items:
There are no special attention items for this release.
| Product | Cat | Subcat | Description | Type | Version | Priority |
|---|---|---|---|---|---|---|
| AMT COBOL | Developer | Code Logic | #85784
In AMT COBOL, EXEC ORACLE keyword 'option' was not implemented. Keyword 'option' has been implemented with parameters PREFETCH, HOLD_CURSOR and RELEASE_CURSOR. |
NEW | AMT 161 | MEDIUM |
| AMT COBOL | Developer | Code Logic | #85800
In AMT COBOL, the Parser did not support DB2’s inline INDICATOR syntax inside INTO lists for SELECT … INTO and FETCH … INTO. As a result, indicator variables were ignored, and null-indicator bindings were missing in the generated code, resulting in errors. The parsing of INDICATOR syntax is now supported. |
FIX | AMT 161 | MEDIUM |
| AMT COBOL | Developer | Code Logic | #85891
In AMT COBOL, EXEC ORACLE 'CREATE TABLE' syntax was not supported. 'Create table' for EXEC ORACLE is now supported. |
NEW | AMT 161 | MEDIUM |
| AMT LION | AmtTools | Application Server/Manager | #92785
INC: 1286014 The AMT Application Server kept resources locked after closing the client if the form logic was in an infinite loop. The 'cancelation' token has been implemented to cancel an infinite loop and free resources. |
FIX | AMT 161 | MEDIUM |
| AMT COBOL | Developer | Code Logic | #94360
In AMT COBOL, EXEC ORACLE syntax with the FOR keyword was not supported for DELETE and INSERT statements. EXEC ORACLE with the FOR keyword is now supported for DELETE and INSERT statements, with a FOR loop being generated to do an INSERT or DELETE for the number of times specified. |
NEW | AMT 161 | MEDIUM |
| AMT COBOL | Generator | Code Logic | #94960
In AMT COBOL, a DB2 DDL with index keys that used functions like TRIM/RTRIM/IFNULL was not converted. Now the generated SQL files support these functions in index keys. |
FIX | AMT 161 | MEDIUM |
| AMT COBOL | Developer | Code Logic | #94977
In AMT COBOL, shorthand 'F' was not recognized as FILLER. Shorthand 'F' and FILLER are now treated the same in migrations. |
CHANGE | AMT 161 | MEDIUM |
| AMT COBOL | Developer | Code Logic | #95003
In AMT COBOL, the EXEC DB2 SQL SET support was missing. EXEC DB2 SQL SET support has been added for Postgres and DB2. |
NEW | AMT 161 | MEDIUM |
| AMT LION | Developer | Web Services | #95096
If a routine was called from a consumable REST API that didn't exist (anymore), no error was shown until generation. Furthermore, this error was unclear. The generation error has been improved so that line number and routine call are mentioned. |
CHANGE | AMT 161 | MEDIUM |
| AMT COBOL | Developer | Code Logic | #95142
In AMT COBOL, EXEC DB2 could not handle host (DATE) variables without an explicit type. A DB2 CAST statement has been added in SQL generation. |
CHANGE | AMT 161 | MEDIUM |
| AMT COBOL | Developer | Code Logic | #95199
In AMT COBOL, the EXEC DB2 ALIAS statement has been migrated to the MSSQL SYNONYM statement when MSSQL databases are targeted. |
NEW | AMT 161 | MEDIUM |
| AMT LION | AMT COBOL | AmtTools | Reo | #95201
In AMT Reorganize, system tables were not always skipped in the analysis phase, as they should be, due to incorrect casing. The System table check has been made case-insensitive. |
CHANGE | AMT 161 | MEDIUM |
| AMT COBOL | Developer | Code Logic | #95234
In AMT COBOL, the Parser did not recognize the DB2 NEXTVAL FOR <sequence> syntax inside expression contexts. The parser has been enhanced to parse the DB2 form NEXTVAL FOR <sequence> statement. |
CHANGE | AMT 161 | MEDIUM |
| AMT COBOL | Generator | Code Logic | #95348
In AMT COBOL, fields in a copy with a DEPENDING ON clause referring to parent fields outside of the copy raised a build error. The generator has been improved to handle such cases. |
FIX | AMT 161 | MEDIUM |
| AMT COBOL | Developer | Code Logic | #95416
In AMT COBOL, ISO was incorrectly interpreted as a column name in EXEC DB2 TO_CHAR statements. The generator has been updated to handle results of both numeric and date expressions in EXEC DB2 TO_CHAR statements. |
FIX | AMT 161 | MEDIUM |
| AMT COBOL | Developer | Code Logic | #95528
In AMT COBOL, REPLACING BY in copies was no longer working. The problem has been solved. |
FIX | AMT 161 | MEDIUM |