ACS 1.1.8.3 SQL Script Assistant! (Video)

The latest version of ACS Access Client Solution 1.1.8.3 has been released for a few days with interesting news in various areas … if you still don’t use ACS and you’re stuck with the old versions Client Access / Iseries Access it’s time to switch to ACS, Java, full of features and cross-platform!

I prepared a video (sorry, only in Italian by now!) for what I consider the most interesting news, which was missing and which is finally available: the autocomplete of SQL statements … a bit like the old STRSQL F4 … the possibility to see fields, tables, views etc. with a simple CTRL + Space (which, I remind you, is also available on Rational Rdi in the RPG / Cobol editor!)

Have a loot to this video:

To download ACS go to the official IBM website:

https://www.ibm.com/support/pages/ibm-i-access-client-solutions

Related Posts
DB2 for i SQL – String Manipulation – POSSTR-LOCATE-LOCATE_IN_STRING (EN)

Introduction Often, in our applications, we need to work with text strings, and DB2 SQL can come in very useful Read more

DB2 for i – FAQ & Howtos (EN)

DB2 Database and SQL ... maybe the most important things on IBM i platform: here's a collection of FAQs, tips Read more

IBM i 7.4 Announcement (En)

Comes directly with the Easter egg this IBM announcement for the news of the IBM i 7.4 version, iNext version Read more

Generated Always Columns (EN)

Introduction "Generated Always Column": are columns, table fields, filled by DB2 engine: something like columns with a default value but Read more

--- Roberto De Pedrini Faq400.com

View Comments

  • Buenas tardes Don Roberto,
    Excelente el post, estos ejemplos aplican sobre ibm i 7.1 ?

    Acs si tengo la versión de la presentación

    Muchas gracias

Recent Posts

Managing Locked Display Files on IBM i: An Effective Solution

We are pleased to receive and share this "tip & trick" from Patrick Rizzi, which introduces a technique that allows…

2 months ago

Monitoring QSYSOPR Messages: SQL to Retrieve Messages and Replies

I take inspiration from a response by Michael Mayer on the Midrange.com mailing lists to someone who asked how to…

2 months ago

Why ERP is the Key to Success for Modern Businesses

Businesses are increasingly seeking tools to enhance efficiency, collaboration, and resource management. Enterprise Resource Planning (ERP) systems provide a comprehensive…

4 months ago

ACS Access Client Solution 1.1.9.5

Early April saw the release of the "Spring Version" of ACS Access Client Solution, version 1.1.9.5 Interesting new features especially…

8 months ago

Tim Rowe and Scott Forstie for CEC 2024 – Milan

If the packed agenda of sessions at Common Europe Congress 2024, June 3-6 Milan, wasn't enough for you, here's another…

8 months ago

Code for IBM i 2.10.0 – Debug IBM i App with Visual Studio Code

Debugging functions with Visual Studio Code have been available for some time but this new version 2.10.0 simplifies the handling…

8 months ago