When using SAS/ACCESS Interface to ODBC in a Unicode SAS session to read PRESTO database files, you can receive the following error:
ERROR: CLI prepare error: [Teradata][Presto] (1060) Presto Query Error: line 1:20: mismatched input '䕓' expecting {'(', 'SELECT', 'DESC', 'WITH', 'VALUES', 'CREATE', 'TABLE', 'INSERT', 'DELETE', 'DESCRIBE', 'GRANT', 'REVOKE', 'EXPLAIN', 'SHOW', 'USE', 'DROP', 'ALTER', 'SET', 'RESET', 'START', 'COMMIT', 'ROLLBACK', 'CALL', 'PREPARE', 'DEALLOCATE', 'EXECUTE'} (1)
The problem occurs because the ODBC driver encoding does not match the Unicode SAS session encoding.
To circumvent the problem, add export EASYSOFT_UNICODE=YES as an environment variable in one of the following:
- your sasenv_local file
- from a UNIX prompt
- an OPTIONS SET= statement