Attribute

StringTruncationMethodForWrites (stmfw)

Purpose

Determines the behavior of the driver when attempting to insert String values that exceed the column length defined in the relational schema.

Valid Values

0 | 1

Behavior

If set to 0 (Keep), the driver inserts String values that exceed the column length defined in the relational schema without truncating the value.

If set to 1 (Error) the driver returns an error when attempting to insert a String value that exceeds the column length defined in the relational schema.

Notes

  • For STRING columns, the driver determines the column size to be 50% greater than the longest sampled value in the column. Setting this option to 0 (keep) allows for inserts with values larger than those identified through sampling to succeed.

Default Value

1 (Error)