------=_Part_3716_12180530.1211398812580
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
FYI friends: There's a bug in the Cheetah2 (IDS 11.50xC1) SPL Dynamic SQL
feature.
Have a function in which you build an SQL SELECT statement based on the
arguments to the function or table contents pointed to by the args in a
string and PREPARE, DECLARE CURSOR, OPEN, FETCH...., CLOSE, FREE CURSOR,
FREE STMT
Now if you call the same function again in the same session with different
args so that the SELECT statement is different, it still executes the
first
statement within that session until you either disconnect and reconnect or
recompile the SPL using UPDATE STATISTICS.
PMR # 80127, 7TD
Bug # idsdb00159990
FWIW. Haven't found a workaround for this one either. Otherwise this new
feature is very nice. 8-{
Art S. Kagel
Oninit
------=_Part_3716_12180530.1211398812580
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
FYI friends: There's a bug in the Cheetah2 (IDS 11.50xC1) SPL Dynamic
SQL feature. <br><br>Have a function in which you build an SQL
SELECT statement based on the arguments to the function or table contents
pointed to by the args in a string and PREPARE, DECLARE CURSOR, OPEN,
FETCH...., CLOSE, FREE CURSOR, FREE STMT<br>
<br>Now if you call the same function again in the same session with
different args so that the SELECT statement is different, it still
executes the first statement within that session until you either
disconnect and reconnect or recompile the SPL using UPDATE STATISTICS.<br>
<br>PMR # 80127, 7TD<br>Bug # idsdb00159990<br><br>FWIW. Haven't
found a workaround for this one either. Otherwise this new feature is
very nice. 8-{<br><br>Art S. Kagel<br>Oninit<br><br>
------=_Part_3716_12180530.1211398812580--
|
