A pet peeve of mine is going into a CL program to make some modifications and then encountering long sequences of Change Variable (CHGVAR) commands utilizing %substring operations in order to access, and then update, data stored in the local data area (LDA). The approach of using the LDA for program-to-program communication is, in many companies, done as an alternative to passing parameters to called or submitted programs. And over the years many of these companies have developed standards addressing how the LDA is laid out for this form of communication. Actual usage of the LDA, however, is often left to the individual developer in terms of implementation. In this article, we will review one possible approach to improve programming productivity when using the LDA.
Still a work in progress, ArdGate allows users to insert, update, and delete data with interactive SQL, QMQRY, and embedded SQL.
Written by Chris Smith
If you want to access data in the DB2 for i database from a remote computer, it's not that difficult. However, if you are working on an iSeries and you wish to connect to a remote database server to manipulate data, it can be a bit of a challenge.