테이블
ook_no title brand_id price
========================================================================
'0002 ' 'AAA3' 2 10.0000
'0003 ' 'AAA4' 3 10.0000
'0004 ' 'AAA5' 4 10.0000
'0005 ' 'AAA6' 5 10.0000
'0006 ' 'AAA7' 6 10.0000
'0007 ' 'AAA8' 7 10.0000
'0008 ' 'AAA9' 8 10.0000
'0009 ' 'AAA10' 9 10.0000
'0010 ' 'AAA11' 10 10.0000
'0011 ' 'AAA12' 11 10.0000
'0012 ' 'AAA13' 12 10.0000
'0013 ' 'AAA14' 13 10.0000
'BU1032 ' 'The Busy Executive''s Database Guide' 1389 19.9900
'BU1111 ' 'Cooking with Computers: Surreptitio' 1389 11.9500
'PS2091 ' 'Is Anger the Enemy?' 736 10.9500
'PS2106 ' 'Life Without Fear' 736 7.0000
'PS3333 ' 'Prolonged Data Deprivation: Four Ca' 736 19.9900
'PS7777 ' 'Emotional Security: A New Algorithm' 736 7.9900
'TC3218 ' 'Onions, Leeks, and Garlic: Cooking ' 877 20.9500
'TC4203 ' 'Fifty Years in Buckingham Palace Ki' 877 11.9500
'TC7777 ' 'Sushi, Anyone?' 877 14.9900
UDF소스
CREATE FUNCTION books_by_brand (v_brand_id INTEGER)
RETURNS TABLE(
book_no CHAR(10),
title VARCHAR(80),
price DECIMAL(19,4))
LANGUAGE SQL
READS SQL DATA
BEGIN ATOMIC
RETURN ( SELECT book_no,title,price
FROM redbooks
WHERE brand_id = v_brand_id );
END;
실행
select books_by_brand(1389) from sysibm.sysdummy1 ---> 안되네요.
|