Skip to main content

How Can I Fix That? Applied Use of ABL2DB on Real World Problems

  • warning: Illegal string offset 'files' in /home/cintegri/public_html/modules/upload/upload.module on line 281.
  • warning: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead in /home/cintegri/public_html/includes/unicode.inc on line 349.
  • warning: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead in /home/cintegri/public_html/includes/unicode.inc on line 349.
  • warning: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead in /home/cintegri/public_html/includes/unicode.inc on line 349.
  • warning: Illegal string offset 'files' in /home/cintegri/public_html/modules/upload/upload.module on line 281.
Printer-friendly version

Legacy applications are often faced with difficult problems of maintenance and enhancement. This difficulty arises because of the lack of meaningful documentation and bad coding practices in the legacy code. When one wants to make enhancements or changes, it can be difficult to identify all affected areas and the full impact of the change. When trying to correct bad legacy coding, it can be difficult to understand the code, making it hard to design good replacement code. We will illustrate the use of ABL2DB to solve this kind of problem, including cleaning up shared variables, migrating database columns from integer to int64, identifying unused database components, and tracking block scope for buffers and transactions.

Presented jointly with James Palmer, Inenco Group at the 2015 PUG Challenge Americas on 8 June 2105 and at the 2015 EMEA PUG Challenge on 5 November 2015.

Code and output for sample reports can be found at