Using a where clause with a 'LOB' datatype like text and image returns error 306:
- ASE version before 15.7
Msg 306, Level 16, State 1
TEXT and IMAGE datatypes may not be used in a WHERE clause, except with the LIKE expression.
- ASE version 15.7 and above
Msg 306, Level 16, State 3:
TEXT, IMAGE and UNITEXT datatypes may not be used in a WHERE clause, except with the LIKE expression and IS [NOT] NULL predicate on columns.
SAP Adaptive Server Enterprise (ASE)
KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem
About this pageThis is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.