Usage Note 61598: The "[Presto] (1060)...mismatched input" error occurs when you use SAS/ACCESS® Interface to ODBC to connect to Presto databases in Unicode SAS®
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
Operating System and Release Information
| SAS System | SAS/ACCESS Interface to ODBC | 64-bit Enabled AIX | | |
| 64-bit Enabled HP-UX | | |
| 64-bit Enabled Solaris | | |
| AIX | | |
| HP-UX | | |
| HP-UX IPF | | |
| Linux | | |
| Linux for x64 | | |
| Linux on Itanium | | |
| OpenVMS Alpha | | |
| Solaris | | |
| Solaris for x64 | | |
| Tru64 UNIX | | |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
The "[Presto] (1060)...mismatched input..." error occurs when using SAS/ACCESS Interface to ODBC to read Presto databases in Unicode SAS systems. To circumvent the problem, specify EASYSOFT_UNICODE=YES environment variable in your sasenv_local file.
| Date Modified: | 2018-01-01 11:10:02 |
| Date Created: | 2017-12-18 12:41:51 |
