The ExecuteNonQueryStatement activity provides the possibility to execute a database statement to an OLE compliant database. It is typically nested within CreateOLEOracleScope or CreateOLESQLScope.
[edit]
Description
| Execute a non Query statement | |
|---|---|
| Name | ExecuteNonQueryStatement |
| Purpose | Execute database statements via OLE |
| Category | UBIK Data Exchange |
| Returns | the number of effected records |
| Version | 2.4.1+ |
Arguments
| Argument | Type | Direction | Purpose |
|---|---|---|---|
| Statement | String | In | The statement to be executed. |
| EffectedRecords | Integer | Out | The number of effected records. If this number is less than 0, the statement execution failed. |
Usage
This activity is used to execute a database statement.
Example
