?????. DB2 ? XpertMon ??? ???!
? ????????? DB ??????.
???? ???? ?? COs(Code Objects) ? ??? ???? ???.
DB2? ????? ???? scalar function? ???? ?? ??? ????? ????.
??? ?? ???? ?? ??? Business Logic? ?? UDF ? ??? ? ????.
UDF? ???? ??? ??? ? ???, ?? ??? SQL? ??? UDF? ????
?? ?? ????? ?????.
SQL Scalar Function
??
DB2 ? ?? 7?? SQL? ???? user-defined function(UDF) ? ??? ? ????.
SQL? ???? UDF? ???? ??? ?? ??? ????.
Host language? ???? ??? ???? ????.
DB2 catalog? ???? ???, Host language? ???? ??? ????? ?? ????.
SQL scalar function? ????? “CREATE FUNCTION” ?? ?????.
function? body ??? SQL ??? ?????. ?, SQL ??? recursive SQL ???,
?? function? call ?? ?????? ????.
SQL ??? ???? Return?? ??? type? RETURN ?? ?? data type? ????? ???.
SQL scalar function ? ?? ? ?? ??? return ? ? ????.
body ?? SQL ??? syscat.functions? body ??? ?????.
??1
???? 2?? ??? ?? SQL Scalar Function? ???? ??? ????? ?????.
- ??? ) CENTER
- ????) CENTER(host variable, length,pad)
- ????) host variable ? ??? ??. ?? ??? pad ??? ????, ?? ??? blank? ??
- ????) ??? ?? SQL Runner ? ??? ??. ???? ?????, ???? ??? ?? ?? 2?? ??
- ????) ??? ?? ??? ??. XYZ ? ???? ????, ??? ??? ‘-‘ ? ????? ? ? ??
??2
- ??? ) DTYPE
- ????) DTYPE (host variable)
- ????) host variable? ?? string?? ‘N’ ?? ??.??? ‘A’? ??
- ????) ??? ?? SQL Runner ? ??? ??
- ????) ??? ?? ??? ??. DTYPE(‘911’)? ????? ‘N’? ??
DTYPE(‘91C’)? C? ???? ‘A’? ??
XpertMon for DB2 UDB V2
DB ???
Tel : 02-2108-1458
Fax : 02-2108-1459
Mobile : 011-896-6545
E-mail :
hjlee@iteg.co.kr
URL :
http://iteg.co.kr