Skip to main content
This property specifies whether the connector supports getting the ResultSet data as an array.
  • 1: The connector returns ResultSet data as an array.
  • 0: The connector returns ResultSet as VARCHAR.
The connector makes the following assumptions when returning the ResultSet as an array:
  • The array columns are always of type Array<String>.
  • The array column data in the result set start and end with bracket characters ( [ and ] ), and the array elements are delimited by commas ( , ).
    This means that multidimensional arrays or array elements that contain commas in their values are not parsed correctly.
Default ValueData TypeRequired
1

Integer

No