Create button in the main menu and select the object type on the New Object section.The DBMS command object is used to execute the following operations with repository database objects:
Extract data.
Operations with table rows:
Insert rows.
Update rows.
Delete rows.
Operations with physical objects:
Create objects.
Replace objects.
Change objects.
Delete objects.
Unlike procedures, creating a DBMS command in the repository does not create any objects on the server.
To create the DBMS command object in the object navigator click the Create button in the main menu and select the object type on the New Object section.
After executing one of the operations the DBMS command creation wizard opens containing the pages:
Basic Settings. The page is used to set object name, identifier and comment.
Parameters. The page is used to create a list of parameters.
DBMS Command. The page is used to determine settings and specify the SQL query, which is used to make changes in database objects.
To save settings in the DBMS command wizard:
Click the Save button.
Select the Save and Close item in the drop-down menu of the Save button. After this the specified settings are saved, the wizard closes, and the window opens in the data edit mode.
NOTE. The Save and Close item is available only on editing the settings.
To open DBMS command for edit, select the corresponding object in the object navigator and execute one of the operations:
Select the Edit item in the DBMS command's context menu.
Select the Edit in a New Tab item in the DBMS command's context menu.
Select the Edit in a New Window item in the DBMS command's context menu.
Press F4.
The DBMS command editing dialog box opens:
Available operations:
The users who have only object read permissions can open the DBMS command for edit without being able to save changes. For details see the Working in Object Navigator section.
See also:
Example of Creating a DBMS Command | Data Handlers in DBMS | ISQLCommand
Execute DBMS command
Settings button.