ARCAD V25

You asked. We listened.

New Release: V25

1. ARCAD Discover

AI Assistant​

  • AI assistant result as Component List ​

CLI (command line)

  • New CLI, New Feature: Retro-Documentation -> Generation of the documentation to Confluence​

Code Diagram​

  • Syntax highlighting, Node – Code link, Code selection, Documentation display improved

Database Diagram​

  • Expand/show less, Arrows between Database nodes​

Diagrams

  • Color Legend, Expand/Collapse incoming or outgoing dependencies, Export Diagram for draw.io/diagrams.net​

Functional Tree​

  • Introduce the concept of applications in MV Diagrams and functional tree, Node Comments, Multiple Object and Source Type Addition​

Healthcheck​

  • Automated Analysis with Diagrams and Dashboards​

IO Diagram Filters​

Macroscopic Views Optimization​

Repository​

  • Drag and drop to working list ​

Settings​

  • Saved Diagram Management​​
  • AI Parameters

2. ARCAD Transformer Microservices​​

Multiple interfaces!

RDi
VS Code

Simplified REST Web Service Deployment for ILE Procedures​

Code refactoring (V24)​

  • Extraction projects, ​
  • Selection of Code, ​
  • Audit of Extractability,​
  • Simulation​
  • Automated Extraction : Create all ILE-required components and replace the extracted code by a call to the ILE procedure

VS Code edition (coming Q1 2025)

3. VS Code

ARCAD Standard/Advanced/Ultimate editions are available from VS Code​

ARCAD extensions for VS Code

Available ARCAD Extensions on the Marketplace

ARCAD VS Code

ARCAD VS Code View

4. SQL​

Support for modern features in IBM DB2​

Support for very deep levels of nested SQL components

For example​:

  • many SQL VIEWs depending on other SQL VIEWS​
  • Usage of SQLUDF modified in SQL components with dependencies
  • Recursive VIEWs​​

Management of multiple types of update

  • DROPS + CREATE Table​
  • ALTER TABLE​
  • CREATE OR REPLACE​

–> Unfortunately no universal method works every time…​
… ARCAD selects different techniques automatically depending on the situation

Management of Security features

  • RCAC Full support​
  • MASK (SQLMASK) and PERMISSION (SQLPERM)

Support of IBM DB2 Modern features

Changes that provide greater efficiency in DB2 for i deployment processes:

  • Individual “Backup” -> Group “backup”​
  • *OPTIMIZE technique to Review (perform a CHGPF or ALTER Table instead of a DROP/CREATE/COPY
  • Compilation always DROP/Create/COPY –> Allow the “Change” option when the file/table exist​s
  • *MULTIJOB Full Support for DB2 components ​
    (taking care of complex cases like interdependencies between Table thru View for example)​
  • Management of View with “… SELECT * FROM …” ​
    (Capability missing from the native IBM API needs to be compensated for)
  • Check the “quality” of the repository for DB2 components
  • Optimization of the ACRTDBRLST command ​
    (better support of VIEW to VIEW relations)​

Management of optimized « Change »​

*COPY – the “historical” method used in ARCAD:

  • After saving in ARRPLOBJ, the old file is deleted​
  • The new file is created (empty for physical files)​
  • For physical files, the data are retrieved by “CPYF” from the saved file​
  • When it’s INDEX, the access path is totally rebuilt

*CHG: New method

  • After saving in ARRPLOBJ, the old file is conserved (not deleted)​
  • A study is done to see if the target file is already “up to date”​
  • If it is already 100% ok: Nothing is done​
  • If not: The existing file is “changed”, using:​
    • CHGPF​
    • CREATE OR REPLACE for TABLE or VIEW​
    • Or ALTER depending the situation​
  • For LF DDS, or for INDEX, it is not possible to complete a “change action”. Instead, we optimize and avoid rebuilding the access path when it is the same)

5. ARCAD Codechecker​

AZURE Plugin in marketplace to enhance Pipeline security​

New Web interface for the management features of ARCAD CodeChecker

Parsing enhancement in the management of copy/includes

New Rules like “Find literals in operations and expressions”​

ARCAD CodeChecker - Visual Studio Marketplace

AZURE Plugins in Marketplace

ARCAD CodeChecker Web Interface

ARCAD CodeChecker Web Interface

Security/Vulnerability Rules

ARCAD CodeCecker Security Rules

ARCAD CodeChecker Security/Vulnerability Rules

Explaination about the Rules

Rule Explanation

Contact Us

TRIAL VERSION / DEMO

Request a trial version or a session in our sandbox!

Try it now!

or

Request a Demo