Usage Note 5997: Access AS400 data using Access Interface to ODBC can cause
ERROR:[merant][ODBC driver][DB2/400] Keyword FOR not expected.
When using SAS/ACCESS Interface to ODBC to access AS400 data through
Merant Sequelink you may encounter the following error:
ERROR:[MERANT][ODBC driver][DB2/400] Keyword FOR not expected.
This problem will occur when issuing a SELECT statement, and it occurs
because the Merant Sequelink driver adds a 'FOR READ-ONLY' clause to the
prepared SELECT statement even though SAS has already add 'FOR
READ-ONLY'.
Currently the only workaround for this problem would be to use an
alternate ODBC driver to access your AS400 data. The IBM provided AS400
ODBC driver does not show this problem
We have patches that can be downloaded from:
V8.2 SAS/ACCESS to DB2:
A Technical Support hot fix for this problem is available at:
http://www.sas.com/techsup/download/hotfix/82_sbcs_prod_list.html#82d204
V8.2 SAS/ACCESS to ODBC :
A Technical Support hot fix for this problem is available at:
http://www.sas.com/techsup/download/hotfix/82_sbcs_prod_list.html#82od02
Operating System and Release Information
| Product Family | Product | System | Reported Release | Fixed Release* |
| SAS System | SAS/ACCESS Interface to ODBC | Microsoft Windows 95/98 | 8.1 TS1M0 | |
| Microsoft Windows 2000 Professional | 8.1 TS1M0 | |
| Microsoft Windows NT Workstation | 8.1 TS1M0 | |
| Windows Millennium Edition (Me) | 8.2 TS2M0 | |
*
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.
| Type: | Usage Note |
| Priority: | medium |
| Topic: | Third Party ==> Information Exchange ==> ODBC (Open Database Connectivity)
SAS Reference ==> LIBNAME Engines
|
| Date Modified: | 2002-04-23 16:19:42 |
| Date Created: | 2001-10-04 12:12:49 |
