JDBC Driver for ServiceNow

Build 22.0.8462

EnforceColumnValues

Controls whether available values for an element are retrieved and checked when executing INSERT or UPDATE statements.

Data Type

bool

Default Value

false

Remarks

Controls whether available values for an element are retrieved and checked when executing INSERT or UPDATE statements. If the value is not a valid choice, an error will be thrown. Elements (columns) in ServiceNow could be limited to a set of valid values (choices in a list). For example, a 'Type of Issue' element could only have valid values like 'Bug','Enhancement' or 'Documentation'. If creating a record with an invalid value, ServiceNow will discard the value and assign a default value for the record. Setting this property to 'true' will retrieve the available choices beforehand, and check if any inserted values are part of the list of valid values when possible. Note that display values are case-senstitive. This property honours the DisplayValue connection property.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462