Previous Topic: Input ParametersNext Topic: Run a Stored Procedure


Output Parameters

ResultsSets

An array of indexed ValueMaps where each item contains the results of a query. The size of ResultsSets matches the number of results sets returned by the SQL statement. Each ValueMap contains the following fields:

Rows

An array of ValueMaps representing the rows of the result set. Each ValueMap contains a field for each column and the value of the column in that particular row.

NullFieldFlags

An array of ValueMaps. The fields of each ValueMap correspond to the fields in rows. The value of each field is either true. The corresponding value in rows is null, or false otherwise. This output only displays if Display null values is selected.

UpdatedRowCounters

An array of integers representing the number of rows updated by the generic SQL statement. If the generic SQL statement performs multiple updates, then this value contains multiple values.

RowCount

(Deprecated) Returns either the row count for SQL Data Manipulation Language (DML) statements or the number of rows in the first result set in ResultSets. If the generic SQL statement performs no updates and returns no results sets, then this value will be set to -1. This field is included for backward compatibility.

OutputParam

The value of the output parameter of the generic SQL statement. If the generic SQL statement does not return any output parameters then this field will not be included in the operator results. The outputParam fields are numbered; for example: outputParam1, outputParam2.

isNullOutputParam

A Boolean value indicating if the corresponding OutputParam value is null. This field only displays if the generic SQL statement returns an output parameter and Display null values is selected.

Reason

Specifies the reason if the operator fails after execution.

Result

Specifies the result of the executed operator.

InputSource
InlineText
InputSourceExpression
MaximumRows
JDBCInputParamArray
JDBCReportNull
UserName
Password
DatabaseType
OtherDatabaseType
DriverName
DatabaseName
CacheBufferSize
BatchPerfWorkaround
ConnectionProtocol
ServerType
DriverType
ServiceID
TNSName
ClientEncryption
ClientChecksum
InstanceName
HypersonicDatabaseType
ServerHost
ServerPort
ConnectionString