IGNORETRUNCATION

Top  Previous  Next

 

DRIVER('SQLDriver', '/IGNORETRUNCATION = TRUE | FALSE ' )

filelabel{PROP:IGNORETRUNCATION} = TRUE | FALSE

 

(NOTE: Not valid for ORACLE Accelerator)

You can declare your string data to be a different size in Clarion than on the server. For example, you can define a CHAR(10000) as CSTRING(50) if all you are interested in is the first 50 characters of the data. However, doing this will generate an ODBC warning about string truncation.

By default, Clarion treats this as a normal error. If you want to ignore this warning, you can set \IGNORETRUNCATION=TRUE, or alternatively, use filelabel{PROP:IgnoreTruncation} = 1.