User-defined methods

You can use user-defined methods to create or modify user-defined structured types. You can call the methods that are defined for a type by using a method syntax or a function syntax.
Method syntax
To call a method by using the method syntax:
  1. In an appropriate context, specify the method name preceded by both a reference to a structured type instance, and the double dot operator.
  2. Follow this with the list of arguments enclosed in parentheses.

Example:

select IDMMX.DM_getClusMdlSpec(modelcolumn)..DM_getNumFields()...
Function syntax
To call a method by using the function syntax:

In an appropriate context, specify the method name followed by, in parentheses, the structured type instance and the list of arguments.

Example:

select IDMMX.DM_getNumFields( IDMMX.DM_getClusMdlSpec(modelcolumn) )...

If the structured type instance is NULL, the method is not called, and NULL is returned.



Feedback | Information roadmap