TruncateLV

Truncates any mainframe long varchar fields to 255 bytes before sending them to the client. Setting this property to no causes long varchar data to be sent as text and image datatypes for 4.x TDS clients, or as the appropriate long varchar datatype for 5.0 TDS clients. (Sybase System 10 and later versions use TDS 5.0.)

Syntax

TruncateLV=[ no | yes ]

Default

no

Values

no turns long varchar truncation off, causing long varchar data to be sent as text and image datatypes for 4.x TDS clients, or as the appropriate long varchar datatype for 5.0 TDS clients.

yes turns long varchar truncation on, truncating any mainframe long varchar fields to 255 bytes before sending them to the client.