SHOW FUNCTION TD_SYSFNLIB.INSTR

Extensibility

SHOW FUNCTION TD_SYSFNLIB.INSTR

I am trying to issue a SHOW FUNCTION on this UDF

In Teradata Administrator I get - 9134 Show function is not supported for Fast Path UDFs

In SQL Asst I get - 5593:  Cannot determine the best-fit function for 'instr'. 

I am trying to deploy a view that uses INSTR through UNITY - which says it cannot parse this view.

I amUnity does not support non deterministic functions and I want to see the function definition to know if it is deterministic or not.

The manuals do not have this information.

Tags (2)
1 REPLY
N/A

Re: SHOW FUNCTION TD_SYSFNLIB.INSTR

Ian,

did you try 'show' on a function executon statement.

I'm not able to test but it might work.

Rglass