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

VsCode Extention: Bob Cozzi’s RPG IV to RPG Free Conversion

👉 Review: Bob Cozzi’s RPG IV to RPG Free Conversion – a useful VS Code extension for RPG modernization If…

2 months ago

IBM i & SQL Tips #010 – Locating Programs in the Call Stack with STACK_INFO

Hello everyone, I’d like to highlight another excellent contribution by Massimo Duca, part of his ongoing IBM i & SQL…

2 months ago

Trying out “Display File DDS Edit” for VS Code

Intrigued by some recent posts from Cristian Larsen on LinkedIn (New Release – Display File DDS Edit v 0.10.1), I…

2 months ago

Project Bob: the next-gen AI partner for IBM i and IBM Z application development

Hello everyone, Today I’d like to draw your attention to a major new announcement from IBM: Project Bob — a…

2 months ago

IBM i & SQL Tips #6: Calling REST APIs and Parsing JSON Responses with SQL

I want to share with you a particularly useful article by Massimo Duca in the IBM i & SQL Tips…

3 months ago

How Parameter Passing Works in IBM i Programs (RPG / Cobol)

Hello everyone, I’d like to highlight a very useful article by Marco Riva on Markonetools, where he clearly explains how…

3 months ago