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.
NOTE. Creating and processing of DBMS commands is available only in desktop application.
Execute the following to create the DBMS Command object in the Object Navigator dialog box:
The Create > Other > DBMS Command context menu item.
The New Object > DBMS Command item in the Create group on the Home ribbon tab.
After executing one of the operations a DBMS command creation wizard opens containing the following pages:
Basic Properties. Object name, identifier and comment are set.
DBMS Command. Determines settings and specifies the SQL query, which is used to make changes in database objects.
To run a database command, double-click appropriate object in the object navigator or select the Open context menu item. The result of running a DBMS command is the number of processed records.
NOTE. The DBMS command is run within the transaction created by the platform. This should be taken into account in the script that uses custom transactions.
If the repository is connected to version control system, the DBMS command can be added to the system to control changes in its version. To do this, select the Add to VCS context menu item for the DBMS command in the object navigator. After adding the object to VCS server it is available to track its changes. Version control system stores DBMS command text and parameter settings. For details about working with objects added to the version control system, see the Developing Applications in a Team section.
See also:
Example of Creating a DBMS Command | Data Handlers in DBMS | ISQLCommand