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

ObjectConnect over TCP/IP

Two and a half years after my post Transferring objects with ObjectConnect and Enterprise Extender, I finally got around to…

8 hours ago

SQL: SELECT with “superpowers”

With a little trick even a simple SELECT statement can execute any system command! Let's see how to do that...

5 months ago

NetServer for everyone – part 5

A mini-serial guide to configuring, managing, using, and troubleshooting the IBM i NetServer

1 year ago

NetServer for everyone – part 4

A mini-serial guide to configuring, managing, using, and troubleshooting the IBM i NetServer

1 year ago

NetServer for everyone – part 3

A mini-serial guide to configuring, managing, using, and troubleshooting the IBM i NetServer

1 year ago

NetServer for everyone – part 2

A mini-serial guide to configuring, managing, using, and troubleshooting the IBM i NetServer

1 year ago