#define | Description |
---|---|
USQL_RESULT_WORKAREA* | The result set is returned as a workarea in the current workspace. Specify optional alias name. |
USQL_RESULT_ARRAY | The result set returned in an array, where each row is a sub-array. |
USQL_RESULT_OBJECTS | The result set returned in an array of objects. By default, all objects are DataObjects where the prototype name is the alias name. |
USQL_RESULT_EVAL | The result set not saved. Instead, each row of the result set is passed as an array to a code block. |
USQL_RESULT_SINGLE_VALUE | The result set is assumed to return only one column/one row. This single value is assigned to <@xResult>. |
|
DatabaseEngine | Result type |
---|---|
PGDBE | USQL_RESULT_WORKAREA |
ADSDBE | USQL_RESULT_WORKAREA |
Embedded SQL engine | USQL_RESULT_ARRAY, USQL_RESULT_OBJECTS, USQL_RESULT_EVAL, USQL_RESULT_SINGLE_VALUE |