SW Infor
SDD-SQL Database Developer
    Web interface to submit ad-hoc SQL statements to DMSII databases
DRS-Database Rest Services
    Rest Services to access DMSII databases using SQL statements
Migration Tools
    Cobol applications to Java/SQL databases/Shell Script

DRS-Database Rest Services

The DRS-Database Rest Services is an application developed to create Rest services that execute SQL statements processed by DMSII databases. Functions are available for infrastructure creation, execution and monitoring of services. The main DRS features are:

	Use of SQL statements to create JSON output. Use of joins between datasets from the same DMSII database or between datasets from different DMSII databases. Parameters for SQL statements. The service can be used imediatly after its creation. Use Unisys-MCPSQL or Unisys-JDBC. Rest services for inquiry or update. Statistics storage and graphical visualization. List of external servers that can send requests.
	The image below shows the service page where you can define the SQL statement, output fields and parameters.

	The following image shows the POSTMAN response.