将db2的函数转为mysql的函数
CREATE OR REPLACE FUNCTION "DB2ADMIN"."GETASNOSBYPNOANDCNO"(pno varchar(10),cno varchar(1))RETURNS table(as_nos varchar(2))LANGUAGE SQLSPECIFIC SQL150907174255300RETURN select as_nos from(select substr(as_nos,'1','1') as as_nos from mcm_xwprd_info where p_no=pno and ft_object=cnounionselect substr(as_nos,'3','1') as as_nos from mcm_xwprd_info where p_no=pno and ft_object=cnounionselect substr(as_nos,'5','1') as as_nos from mcm_xwprd_info where p_no=pno and ft_object=cnounionselect substr(as_nos,'7','1') as as_nos from mcm_xwprd_info where p_no=pno and ft_object=cno) where as_nos !=''
天盟APP下载
