02a - SQL (EN)02b - IBM i Tuning and admin (EN)

ACS 1.1.8.3 SQL Script Assistant! (Video)

Last Updated on 1 January 2020 by Roberto De Pedrini

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
About author

Founder of Faq400 Srl, IBM Champion, creator of Faq400.com and blog.faq400.com web sites. RPG developer since I was wearing shorts, strong IBM i supporter, I have always tried to share my knowledge with others through forums, events and courses. Now, with my company Faq400 Srl, I help companies to make the most of this great platform IBM i.

2 Comments

Leave a Reply

Your email address will not be published. Required fields are marked *