Usage Note 55648: The SAS® VIEWTABLE editor closes very slowly when you view large ODBC tables in UNIX operating environments
In UNIX operating environments, the VIEWTABLE editor can close very slowly (taking minutes) when you use SAS/ACCESS® Interface to ODBC to connect to and view large tables. This problem is likely to occur when you use very large tables that contain millions of rows or more.
The problem occurs because of a vendor issue in the Progress DataDirect driver. To resolve the problem, add the following driver option to your odbc.ini file.
CancelOnStatementClose=1
Operating System and Release Information
| SAS System | SAS/ACCESS Interface to ODBC | 64-bit Enabled AIX | 9.4 TS1M2 | |
| 64-bit Enabled Solaris | 9.4 TS1M2 | |
| HP-UX IPF | 9.4 TS1M2 | |
| Linux for x64 | 9.4 TS1M2 | |
| Solaris for x64 | 9.4 TS1M2 | |
*
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.
Large tables that are displayed with the VIEWTABLE editor can close very slowly when you use SAS/ACCESS® Interface to ODBC to connect to those tables. The problem can occur when you use Progress DataDirect drivers. To solve the problem, add the CancelOnStatementClose=1 to the odbc.ini file
| Date Modified: | 2015-05-06 12:40:47 |
| Date Created: | 2015-04-24 10:17:24 |
