Yes, everyone have to setup the CAST for their query. But Looking for SAS system options otherwise we may need to setup the views for the users. ... View more

we are in the similar situation. DBMAX_TEXT or TEXTSIZE option is not worked for us. I believe it works for BLOB types. did any of you get it work or any other system options to restrict length of the column? ... View more