.executeSQLStatement()

Executes a SQL statement.

Returns the 'this' object.

Syntax

.executeSQLStatement( sql-statement, options )

options := {

hostvars: hostvars

, async: async

, hostvars: hostvars

, success: success-function

, error: error-function

}

async := { true | false }

The required sql-statement identifies the SQL statement to be executed.

Options is a struct that can have the following items, all of which are optional.

Hostvars is a struct containing name-value pairs that specify input values for the SQL statement.

Async is a boolean determining whether the operation is executed asynchronously. The default is false, meaning that the operation is executed synchronously by default.

Success-function is a function called after the operation has successfully completed.

Error-function is a function called if an error occurs.

Example

$.udb.executeSQLStatement( 'MySQL', {hostvars: {ID:'NL01234'}, async:true} );