The DBMS Command page is used to set a database, connection with which is used to run the command, and a DMBS command text.
Set the parameters:
Select Database/Database. Use the drop-down list of repository objects to select the database. The driver, specified in settings of the selected database, is highlighted with bold font, is set automatically when changing a database.
Drivers/Driver. Select the driver type in the drop-down list. For details about available drivers see the Supported DBMS subsection. The Driver list displays a default driver highlighted with the bold font, which is used in the selected database. If required, one can select another driver and specify the SQL query text for this driver. It is relevant if the repository is to be used on servers with different DBMS and settings in repository are to be changed.
Statement. Enter command text in the SQL language.
NOTE. On entering the command text, take into account differences of SQL language that may appear in different DBMS versions.
Apply for All DBMS. The button determines command text for all DBMS, that is, changing the driver does not affect command text. Clicking this button returns a request to confirm the operation. Confirmation is required if at least one driver differs from the current one, has non-empty query text.
See also: