TRANS is a highly productive unique set of integrated "Lower-Case" tools that offers the programmer all the elements necessary to design the most advanced software.
TRANS includes all the necessary functionality for the definition and maintenance of databases. It allows the SQL Data Definition Language (DDL) to be easily and transparently used by the programmer through data entry programs.
All the important aspects of the maintenance of the database structure that applications will later use are included: database creation and maintenance, Tables, Columns, Indexes, Views, etc.
TRANS automatically maintains a programming catalogue that comprises all the information about the objects that make up the application that the programmer is developing (programs, modules, tables, indexes, columns, etc). It contains data such as:
During the development of an application on a database, TRANS allows all its modules and programs to be compiled automatically, a prototype to be generated from a schema and information about all the elements that the application comprises to be obtained.
In the same way, TRANS permits the directories where the different elements will be saved to be defined.
In the case of prototype generation, TRANS will design a data entry program, a report program and a query program for each of the tables contained in the database. Finally, a "pull-down" menu will comprise all the generated programs.
The TRANS modules responsible for giving programming support allow modules and programs to be defined, programs to be classified, modules to be edited, compiled, executed, debugged and corrected, program linking, program and module classifications changes, program or module renaming, etc. In short, all those tasks related to the development of application programs are included.
Likewise, TRANS takes care of the maintenance, editing and compilation of the application help files.
For those occasions in which the programmer needs to use the SQL interactively, TRANS provides a menu to edit, test, save, catalogue, etc. SQL statements.
In this way, everyday needs such as the testing of SQL statements that will be included in programs at a later stage, the cancellation of operations undertaken by a program on a database or the measurement or different statements' run times obtain a simple and efficient solution.
In order to rapidly create the first versions of the different application programs, TRANS offers a series of options to generate the code. The programs generated will automatically form part of TRANS’ programming catalogue and can therefore be edited, modified, etc. at a later stage as though they were created by the programmer himself.
The code generator is able to create the following different program types:
In the case of menus, the code generator designs a menu program that comprises all the programs throughout the application developed until that moment.
One of the most painstaking and time-consuming tasks is the creation of the developed application's documentation. In this respect, a set of options is provided for any application developed with TRANS that permits both the user and programmer documentation to be automatically generated. In this way, the application's documentation is not only considered as something obvious, but at the same time is maintained up to date with the latest application status.
The documentation generators analyze and sort all the information contained in the programming catalogues, database structure, help files and the application programs. They use this information to generate a manual structured in chapters, sections and subsections.
There are 2 documentation levels:
1. User Documentation.
TRANS allows a program or application's User Manual to be generated automatically,
i.e. it permits a program to be documented separately or the entire application's
documentation to be generated from a program. In this case, the entry
program and all nested programs to any level are scanned. The documentation
generated can be printed and edited in order to incorporate any modification
the programmer deems suitable.
2. Programmer Documentation.
In order to generate the programmer's documentation, TRANS uses all the
information contained in the programming and database system catalogues
to elaborate an ordered manual that permits the application and its structure
to be rapidly understood and provides information on all relevant aspects.
This manual will contain information such as:
