Papyrus TypeManagers

provide simple user and application access to any supported database without coding SQL and the need for acquiring or installing database clients on each PC.

The TypeManager is instantiated by the developer on a database server. A simple IMPORT command will extract the table definitions and create CLASS definitions in the Papyrus Repository. With these definitions, the developer or administrator can now define business object TEMPLATES. One row of the DB would typically represent one object instance. In these definitions, the fields of the tables are mapped to the defined business object. Queries produce a list object, which is a table extract of the database. In this query template the user can now edit the search or key criteria. This is much simpler to use than SQL.

Once the data is entered the user can drag the query to the TypeManager and drop it. This will execute the search in the database. Alternatively the user can also click on 'GET DATA' in the query template.

In the above view, the message window is opened so that the Oracle DB messages can be seen. In case the query returns more than one row, a QUERY LIST is created containing the hit list.

The query list object can be used immediately in any Papyrus application as an input data object. This object can also be used in any other application. It can also be saved as an ASCII delimited or XML tagged file.