external table function in DB2 LUW

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

monishkar@gmail.com - 22 Feb 2006 13:38 GMT

Can two external table functions in DB2 LUW have the same name even
though they have different specific_name? Thanks.

Reply to this Message

Serge Rielau - 22 Feb 2006 14:13 GMT

> Can two external table functions in DB2 LUW have the same name even
> though they have different specific_name? Thanks.

Absolutely.
The requirement is that at least on of the parameters must be a
different type.
E.g.
CREATE FUNCTION FOO(INT) RETURNS TABLE(c1 INT) ...
CREATE FUNCTION FOO(BIGINT) RETURNS TABLE(c1 INT) ...

SELECT * FROM TABLE(foo(5)) AS X => invokes FOO(INT)
SELECT * FROM TABLE(foo(CAST(5 AS BIGINT))) AS X => invokes FOO(BIGINT)

Also check out teh type promotion rules.

Cheers
Serge

Signature

Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

Reply to this Message