Invoking the UDFs

To call the UDFs described in the chapter CTP UDFs, you must invoke the Teradata BTEQ query tool using the following command:

ASCII login:

# bteq [.logon <UserID>,<Password>]

Unicode login:

# bteq -e UTF8 -c UTF16 [.logon <UserID>,<Password>]

You can call the UDFs as follows:

BTEQ -- Enter your SQL request or BTEQ command:
select thales.<UDF name>(<UDF parameters>);

You can also perform other BTEQ functions at the prompt.