dbmax_text parameter on caslib to odbc data source - SAS Viya 3.5

[claudiodejesusa]

Hi everyone,

I'm working with SAS Viya 3.5 with Azure Databricks, i have connection with ODBC, but i got some problems when i try to establish a caslib to data source odbc and want to add parameter dbmax_text. This parameter is success with JDBC, but in ODBC is the problem.

Do you know the correct syntax? I use this parameter because of my database has string fields and when the data go to SAS i want tu manage the length of the string converted to char type on SAS.

Thanks for the support

Claudio

[SASJedi · Accepted solution]

DBMAX_TEXT is not one of the supported options for the CAS ODBC data connector in Viya 3.5 (and even in Viya 2023.9). I don't have access to a Viya instance using ODBC to access STRING data types, but you should give the connection a try without using DBMAX_TEXT. Remember that, unlike base SAS data sets, CAS tables support the VARCHAR data type.