...
| Info |
|---|
A database connection needs to be created under DB Connect (Configure > DB Connect) and the created variable can then be used in the Database String parameter for various database keywords. |
Database Connection String format : Type | Name / IP Address : Port | SID | Database Name | User Name | Password
...
Oracle
MySQL
SQL Server
Postgres
Let us assume, the DB Connect variable created is bqdbString with values MySQL | 192.9.9.9 | 9999 | Schema 1 | abcde | xxxxxxxx. This variable can now be used in keywords with parameter Database String.
Suppose you wish to execute an update query on the database.To know how to establish a connection with the Database, please go through the DB Connect document.
Structure :
executeUpdateQuery <parameters>
...
| Filter by label (Content by label) | |||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
| Page Properties | ||
|---|---|---|
| ||
|
...