MQT Archives - IT Jungle

Guru: ACS 1.1.8.3 Content Assist Includes Prompt For SQL!

February 10, 2020 Birgitta Hauser

STRSQL, the green-screen facility for executing SQL Statements, has had its days. Nevertheless, many SQL users still prefer this legacy interface over the Access Client Solutions (ACS) Run SQL Scripts facility. Others use third-party tools to execute SQL statements. The common excuse has been that the Run SQL Script facility does not include a way to prompt SQL commands, tables, and columns. In ACS version 1.1.8.3, Content Assist includes prompting for SQL statements.

Before ACS Version 1.1.8.3, no prompting was available within the Run SQL Scripts Facility. To access tables, views or materialized query tables (MQTs), we needed to know …
Read more
PTC Completes Database Support In Implementer

September 11, 2019 Alex Woodie

As a change management tool, PTC’s Implementer is well-regarded among IBM i users for its ability to track development tasks and smooth out the promotion process. While the product has mostly been used to track source code in programming languages like RPG and Java, customers have increasingly been putting business logic into Db2 for i. With the recent launch of Implementer 12.3, PTC has wrapped up planned enhancements for the database.

PTC‘s Implementer provides a full range of capabilities for managing development processes for IBM i shops. The software works closely with IBM‘s Rational Developer for i (RDi) …
Read more