Databases

Version en español

Two databases are used (at least), one for ABL code information (xrefsrc) and the UML repository database (Repository).

Attached are the xrefsrc database tables definitions, repository sql definition (modified) and sql sequences creation (for repository db). Repository database creation is somehow complicated, and out of scope, you can see details in ABL2UML.

If you use the original repository structure (ABL2UML or Sparx provided) you will need to change some fields type, or the code will fail (fixchar type unaccesible to ABL code).

xrefsrc database has two tables:
- xrfdat
- xrfprg

xrfdat holds relationship details between code components, this is include, run and data access information. xrfprg holds the information that lets you know when a component (.p) is a functional unit (actually the initial program of the functional unit) or part of another funcional unit, and two descriptions (optionals) that are used to generate notes and alias info.

We have also used a third database for storing menu structure information (mapsissrc), the structure is provided so distributed code can be run without modifications.


AttachmentSize
repository.zip7.3 KB
dfs.zip1.58 KB