Up to Discussions in Enzee Universe

This Question is Answered

1 "helpful" answer available (2 pts)
3 Replies Last post: Dec 7, 2009 10:51 PM by Jeff Feinsmith  
gb2312  
gb2312
11 posts since
Nov 30, 2009
Currently Being Moderated

Dec 7, 2009 9:04 PM

how to get the user defined function signature?

Hi,

 

I can find two cloumns in _v_function system tables, but these columns(arguments, functionsignature ) only have the variable type

eq:TESTXML_ABC(DOUBLE PRECISION, DOUBLE PRECISION, DOUBLE PRECISION, DOUBLE PRECISION, DOUBLE PRECISION, CHARACTER VAR

 

I need to know the variable name, I guess in some table or view might store them, but I can not find such information in user guide.

 

Thanks,

Frank

Jeff Feinsmith  
Jeff Feinsmith
8 posts since
Mar 28, 2007
Currently Being Moderated
1. Dec 7, 2009 9:53 PM in response to: gb2312
Re: how to get the user defined function signature?

The variable names are not specified.  Prototype can be retrieved via:

 

SELECT Result, Function, builtin, Arguments
FROM _v_function WHERE Result <> '-' and Arguments <> ''
AND Function like ^myUDF%^ ORDER BY Function, Result, Arguments;

 

-Jeff

Report Abuse
gb2312  
gb2312
11 posts since
Nov 30, 2009
Currently Being Moderated
2. Dec 7, 2009 10:44 PM in response to: gb2312
Re: how to get the user defined function signature?

Jeff,

 

Thanks a lot!

 

I use that sql get similar result for arguments column

myfunction(DOUBLE PRECISION, DOUBLE PRECISION, DOUBLE PRECISION, DOUBLE PRECISION, DOUBLE PRECISION, CHARACTER VARYING(7), ...)

 

May be I do not explain the question clearly.

 

I need get the name of the parameter,DOUBLE PRECISION is the parameter type,

for example, 'income' is a function parameter , its type is DOUBLE PRECISION.

 

I need get the string 'income'  from DB, is it available for Netezza table or views?

 

Thanks,

Frank

Report Abuse
Jeff Feinsmith  
Jeff Feinsmith
8 posts since
Mar 28, 2007
Currently Being Moderated
3. Dec 7, 2009 10:51 PM in response to: gb2312
Re: how to get the user defined function signature?

Like I was saying, the information you are looking for does not exist.  With Netezza functions, you do not need to use specific variable names as they are not specified nor specifiable in the prototype.  You merely need to make sure you are putting the right types in the right positions for the function call.  In order to determine what each position is responsible for, please refer to the documentation on the specific function.

 

-Jeff

Report Abuse

More Like This

  • Retrieving data ...