The article provides description and examples of use of data handlers in DBMS. In Foresight Analytics Platform the following handlers are implemented to process data in DBMS:
A DBMS command object is used to execute the following operations on repository database objects:
Extract data
Insert, update and delete table rows
Create, replace, modify and delete physical objects.
Unlike procedures, creating a database command in the repository does not create any objects on the server.
The Procedure object enables the user to create procedures and functions for various DBMS.
Unlike the DBMS command, a stored procedure or function is created on the server when the Procedure object is created in the repository. Several repository procedures may refer to the same stored procedure on database server. Changes in text of a stored procedure affect all objects referring to this procedure. The result of a procedure is the number of processed records, or some specific value if a function is created instead of a procedure.
NOTE. It is available to create and work with procedures only in the desktop application.