How to get a list of internal functions

Database
Fan

How to get a list of internal functions

Hello all,

I am trying to get a list of all functions available in Teradata along with info about the number of parameter that a function uses.
For instance, substr needs 3 parameters and trim needs 1 parameter.

I was able to get these kinds of info from DBC.FunctionsX for user-defined functions but don't see anything for Teradata-defined functions.
Any help is greatly appreciated.

Best regards...
2 REPLIES
Enthusiast

Re: How to get a list of internal functions

Hi,

You can try the following command to get the list of DBS SQL commands and functions:

help 'SQL'

and if u want to know more about the function say (ABS) you can give:

help 'SQL ABS'
Fan

Re: How to get a list of internal functions

Grao,

THANK YOU for the reply... Do you know if there is a view similar to functionx to see the information in more structured format?

thanks!