In addition to the IFS-related Run SQL Scripts function mentioned above, IBM included two other IFS updates with this release. With version 1.1.8.2, administrators are given the option of removing the system name on printed output download path, providing for a cleaner look.
Normally, the printed output contains the system name. Lastly, in the JDBC Connection dialog, IBM is including the capability to assign alternate server names and other attributes.ĪCS has printer emulation, allowing users to print directly from ACS. If there is a problem with the SQL syntax, the new Formatter will highlight the error, including the line number and the issue.Īuthorized users can also now access and update data values in Db2 for i fields directly from within the Run SQL Scripts interface, a powerful feature that could be a real timesaver - or a security liability if not properly secured. Getting the SQL syntax perfect will also be easier thanks to a new design in the Formatter portion that “enables it to understand SQL syntax,” IBM says. From this point forward, IBM will include any new SQL examples with its “insert from examples” functionality. IBM provides a host of example SQL scripts that workers can use with the software. So let’s go through the enhancements in ACS version 1.1.8.2 by functional area, starting with Run SQL Scripts, enables users execute SQL queries against Db2 for i, and which is one of ACS’s most popular functions.įor starters, users can now open and save SQL scripts to the IFS and stream files, which IBM says “extends the options for how scripts are maintained and used.” The software will also remember which database you prefer to work with and retain iASP connections, both of which will save time. Getting up to speed on ACS is even more important now that IBM i Access for Windows was withdrawn from marketing on April 30. The Java-based product, which IBM unveiled in August 2012, brings several handy components, including a 5250 emulator, 5250 printer emulation, data transfer capabilities, IFS file viewing, spool file management, and a virtual console for LAN and HMC management.
Until now, that is.ĪCS, in case you forgot, is IBM’s strategic desktop client for accessing IBM i. There’s been so much news – starting with the availability and security enhancements in Db2 Mirror and Authority Collection enhancements – to keep the IT Jungle news team busy that we haven’t gotten to ACS version 1.1.8.2. There’s no denying that IBM delivered a whopper of release with IBM i 7.4 and its sidekick, IBM i 7.3 TR6. Database engineers and system administrators are the big winners with this release. IBM Bolsters ACS with Database and Administrative GoodiesĪmid the many enhancements that IBM has delivered with IBM i 7.4 and IBM i 7.3 TR6 is a new release of Access Client Solutions (ACS), which has become the go-to client interface that many IBM i professionals use to access the system for a variety of tasks.
0 kommentar(er)
