>>>>>>>> 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