Skip navigation
Up to Discussions in Enzee Universe
14474 Views 3 Replies Latest reply: Dec 7, 2009 10:51 PM by Jeff Feinsmith RSS
gb2312 New Enzee
gb2312
27 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 New Enzee
    Jeff Feinsmith
    13 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

  • gb2312 New Enzee
    gb2312
    27 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

  • Jeff Feinsmith New Enzee
    Jeff Feinsmith
    13 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

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • Correct Answers - 4 points
  • Helpful Answers - 2 points