SAS Note V6-SERVER-F930

From: tsdlist@UNX.SAS.COM
Date: Thu Jul 08 1999 - 09:27:50 EDT


>>>>>>>> SAS Notes -- Copyright (c) 1991 - 1999 by SAS Institute Inc. <<<<<<<<

V6-SERVER-F930 *** ALERT NOTE *** PRODUCT: SPDS
                                                        PROCEDURE: SERVER
TITLE: pass-through WHERE with put/input formats & functions returns extra rows

KEYS: ROWS MANY TOO RETURN FORMATS PUT INPUT WHERE PASS-THROUGH CANNOT MAINTE
       EVALUATE CLAUSE SPDS SQL PROC FUNCTIONS EXTRA 99.05.01 ALERT SERVER SPD

    Pass-through WHERE clauses that contain a put/input with format or a
    function can return too many rows with no indication of a problem.
    Pass-through WHERE clauses with formats and functions were not supported
    in TS015. With Scalable Performance Data Server 2.1 TS015 Maintenance
    level 99.05.01 and TS020 Maintenance level 99.05.01, put/input
    formatting and functions are supported on an experimental basis when
    used in a Pass-through WHERE clause.

    The following is an example of a WHERE clause that is now experimentally
    supported:

        select * from connection to sasspds (select * from emptbl
           where YEAR(hiredate)=1989);

+------REPORTED------+ +---FIXED---+
SYSTEM RELEASE LEVEL RELEASE LEVEL

AIX/R 2.1 TS010 2.10 TS015
HP800 2.1 TS010 2.10 TS015
Solaris 2.1 TS010 2.10 TS015
WIN/NT 2.1 TS010 2.10 TS015



This archive was generated by hypermail 2b29 : Mon Jan 10 2000 - 10:10:19 EST