• More Database Tools Highlight Latest IBM i Access Client

  September 18, 2017 Dan Burger

  Remember IBM i Access for Windows? Many IBM i advocates do because they never stopped using it, despite its replacement by IBM i Access Client Solutions more than four years ago. Access for Windows hasn’t seen an enhancement since ACS arrived and ACS is on a continual enhancement schedule. The most recent round of upgrades arrived in mid-July without much fanfare, which is the way IBM seems to prefer.

  SQL developers and database engineers (those that have the title and those that only have the responsibility) are among the professionals benefiting the most from the expanding ACS toolset that usually … “More Database Tools Highlight Latest IBM i Access Client”

  Read more

• Top Ten New IBM i RFEs

  May 22, 2017 Alex Woodie

  Should IBM open source its database drivers, or add support for .NET? Should it add the latest SSL ciphers to IBM i 7.1? These are some of the changes that it has received through its new Web-based requests for enhancement (RFE) program on its developerWorks site.

  The new RFE functionality is only a few months old, but it’s already attracting the attention of IBM i professionals who want IBM to change things about the stack. It’s also getting attention from other IBM i pros who get to vote on them.

  Here are the top ten RFEs so far, ranked by … “Top Ten New IBM i RFEs”

  Read more

• Guru: SQL Table Functions Can Do Non-function Things

  May 1, 2017 Ted Holt

  We IBM i developers owe a great debt to Scott Forstie. He’s responsible for the wonderful DB2 for i Services and IBM i Services, which give us SQL interfaces for many functions of the operating system. Like IBM, we can write SQL interfaces to help us with non-database tasks. I recently did exactly that.

  While I can’t say that I never use the Start SQL Interactive Session (STRSQL) command, I can say that I prefer to use GUI SQL clients, in particular the Run SQL Scripts utility that is part of IBM i Access Client Solutions (ACS). I do get … “Guru: SQL Table Functions Can Do Non-function Things”

  Read more

• ACS Getting New Database Schema Functions

  March 29, 2017 Alex Woodie

  IBM is adding more functionality to the upcoming release of Access Client Solutions (ACS) that should make IBM i database engineers and database developers very happy, including a new capability that allows users to work directly with schemas.

  The database schema function was not on the list of new ACS features that IBM released back in February, when it first unveiled IBM i 7.3 TR2 and IBM i 7.2 TR6. IBM uses the major operating system and technology refresh (TR) announcements as a vehicle to also announce other products that aren’t part of the OS proper, but which are … “ACS Getting New Database Schema Functions”

  Read more

Next Articles