i am using UDB 9.5 on windows... am trying to select 2 columns into
2 variables and can not get it to work...i can use the set if only
pulling one field back but i want to set 2 fields in the select..
any ideas how to get around this or why DB2 does not support this?


SET V_CCPA_I = (
SELECT CCPA_I -, NAME
--INTO V_CCPA_I , V_NAME
FROM TABLE(DCS.GET_STOP_OWNER(NEW.ACT_I)));

SET (V_CCPA_I, V_NAME) = (
SELECT CCPA_I, NAME
FROM TABLE(DCS.GET_STOP_OWNER(NEW.ACT_I)));



--
Serge Rielau
SQL Architect DB2 for LUW, IBM Toronto Lab
Blog: tinyurl.com/SQLTips4DB2
Wiki: tinyurl.com/Oracle2DB2Wiki
Twitter: srielau