SN-005694 ***Alert Note***
VIEWTABLE, Table Viewer, and Data Table WHERE clauses may return
incorrect results through SAS/CONNECT RLS
Product: SAS/CONNECT
Component: Remote library services
Priority: ALERT
When scrolling through a remote SAS data set one row at a time using
either a Table Viewer control with a SAS Data Set Model, a Data Table
object within a SAS/AF FRAME entry, or the VIEWTABLE window, rows of the
remote data set may be erroneously omitted.
All of the following conditions must exist in order to experience this
problem:
1) The remote data library is allocated through SAS/CONNECT's
Remote Library Services (RLS).
2) The remote data set has been opened in edit mode.
3) One or more indexes exist in the data set.
4) A WHERE clause has been applied on the indexed variable.
5) The number of rows in the WHERE filter's result set fail to
all fit inside a single screen.
To circumvent this problem, eliminate any one of the above conditions
from the processing. Other alternatives include: view the data set
in the FSVIEW window, use form view mode of a VIEWTABLE window, a form
viewer with the SAS data set model, or a data form object.
Keywords:
viewtable table viewer table where clause return incorrect results edit
connect rls remote library services engine af tableviewer sasdataset sas
data set model datatable rowleveledit tableleveledit index scroll
vscroll editmode setwhere
viewtable, table viewer, and data table where clauses may return
incorrect results through sas/connect rls
005694 5694
SAS Note Revised On: Wed, 22 Aug 2001
System Version Reported Version Fixed
AIX/6000 8.1 TS1M0
VM/ESA (CMS) 8.1 TS1M0
Compaq Tru64 UNIX 8.1 TS1M0
HP-UX Operating Systems 8.1 TS1M0
Intel ABI 8.1 TS1M0
MIPS ABI 8.1 TS1M0
OS/390 (MVS) 8.1 TS1M0
IBM OS/2 8.1 TS1M0
Solaris 8.1 TS1M0
OpenVMS VAX 8.1 TS1M0
OpenVMS Alpha 8.1 TS1M0
Windows NT 8.1 TS1M0
Windows 2000 Datacenter Server 8.1 TS1M0
Windows 2000 Professional 8.1 TS1M0
Windows 2000 Server and Advanced Server 8.1 TS1M0
Windows 95 8.1 TS1M0
Windows 98 8.1 TS1M0
No Fixes Available
+-------------------------------------------------------------------------
+ NOTE: To unsubscribe you can reply to this mail with:
+ "SIGNOFF tsnews-l"
+ as the only text in the body of the message (without the double quotes).
+ If you have any questions please send them to SUPPORT@SAS.COM
+-------------------------------------------------------------------------
This archive was generated by hypermail 2b29 : Wed Aug 29 2001 - 13:08:10 EDT