The following table summarizes the SQL data types for the parameter list and return type of CREATE FUNCTION statements that register support functions.
| Support
Function |
Parameter
Type |
Return Type | Refer to |
|---|---|---|---|
| input | lvarchar | opaque data type | page Input Support Function |
| output | opaque data type | lvarchar | page Output Support Function |
| receive | sendrecv | opaque data type | page The Send and Receive Support Functions |
| send | opaque data type | sendrecv | page The Send and Receive Support Functions |
| import | impexp | opaque data type | page Import and Export Support Functions |
| export | opaque data type | impexp | page Import and Export Support Functions |
| importbinary | impexPbin | opaque data type | page Importbinary and Exportbinary Support Functions |
| exportbinary | opaque data type | impexpbin | page Importbinary and Exportbinary Support Functions |
| assign | opaque data type | opaque data type | page The assign() Function |
| destroy | opaque data type | - no return value - | page The destroy() Function |
| update | opaque data type,
opaque data type |
opaque data type | page The update() Function |
| deepcopy | opaque data type | page The deepcopy() Function | |
| lohandles | opaque data type | - list of pointers - | page Handling Smart Large Objects |
| compare | user-defined type,
user-defined type |
- integer values to show less than, greater than and equal - | page Comparing Data |
In the preceding table, opaque data type is the name of the data type that you specify in the CREATE OPAQUE TYPE statement. For more information, see Registering the Opaque Data Type.
When the CREATE FUNCTION statement stores a new support function in sysprocedures, it causes the database server to assign a unique value, called a routine identifier, to the support function. Throughout the system catalog a support function is identified by its routine identifier, not by its name.
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]