We are trying to connect to a SAS/SHARE server from Denodo, using the SAS JDBC driver.
Our table in our SAS server has a field called *value* and when we query that table through Denodo, the SQL generated by Denodo wraps the field name in double quotation marks :
`SELECT t0."value" FROM SASLIB.SASTAB t0`
which is not recognized by SAS.
Any way to set denodo to avoid wrapping field names with quotation marks when delegating the query ?
We do understand it's done that way because value is a reserved word, but in that case it prevents us from querying the sas dataset entirely.