SAS Institute Alert Note SN-005694

From: SAS Technical Support (LISTSERV@VM.SAS.COM)
Date: Wed Aug 29 2001 - 12:46:04 EDT

  • Next message: SAS Technical Support: "SAS Institute Alert Note SN-005697"

    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