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 coloration, 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​​
  • IA 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 needed components and replace the Extracted call by the call of the ILE procedure

VS Code edition (coming Q1 2025)

3. VS Code

ARCAD Standard/Advance/Ultimate are covered with VS Code​

ARCAD extensions for VS Code

Available ARCAD Extensions on the Marketplace

ARCAD VS Code

ARCAD VS Code View

4. SQL​

Support of IBM DB2 Modern features​

Support of Very deep level of Nested SQL component imbrication

For example​:

  • many SQL VIEW depending to Other SQL VIEW​
  • Usage of SQLUDF modified into SQL components with dependencies​
  • Recursive VIEWs​​

Management Of Multiple type of Update

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

–> Unfortunately No Universal Method works at any time…​
… ARCAD ses/choses different techniques automaticaly depending the Situation

Management of Security feature

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

Support of IBM DB2 Modern features

Changes that provides More efficieny in DB2 for i deployment Processes :

  • Individual “Backup” -> Group “backup”​
  • *OPTIMIZE technique to Review (It’a about doing a CHGPF our ALTER Table instead of a DROP/CREATE/COPY​
  • Compilation always DROP/Create/COPY –> Allow the “Change” possiblity when the file/table exist​
  • *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 …” ​
    (Missing capability of the native IBM API need to be compensated)​
  • 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: It’s 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’s not possible to realize a “change action”, but a “trick” is used; it avoids to rebuild the access path (when it’s the same)​

5. ARCAD Codechecker​

AZURE Plugin in marketplace to enhance Pipeline security​

New Web interface for the Management side of ARCAD of Code checker (first batch)

Parsing evolution to enhance 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

Explaination about the Rules

Contact Us

TRIAL VERSION / DEMO

Request a trial version or a session in our sandbox!

Try it now!

or

Request a Demo