CREATE [ INSTANCE | CONSTRUCTOR ] METHOD [SYSUDTLIB.] method_name ( locator_specification [,...] ) RETURNS return_data_type [ CAST FROM cast_data_type ] FOR UDT_name [ USING GLOP SET GLOP_set_name ] EXTERNAL [ NAME { external_method_name | 'item_list [ delimiter... ]' } ] [ EXTERNAL SECURITY { DEFINER [ authorization_name ] | INVOKER } ] [;]
- locator_specification
[ parameter_name ] data_type [ AS LOCATOR ]
- data_type
{ INTEGER | SMALLINT | BIGINT | BYTEINT | DATE | { TIME | TIMESTAMP } [ (fractional_seconds_precision) ] [WITH TIME ZONE] | INTERVAL YEAR [(precision)] [TO MONTH] | INTERVAL MONTH [(precision)] | INTERVAL DAY [(precision)] [TO { HOUR | MINUTE | SECOND [(fractional_seconds_precision)] }] | INTERVAL HOUR [(precision)] [TO { MINUTE | SECOND [(fractional_seconds_precision)] }] | INTERVAL MINUTE [(precision)] [TO SECOND [(fractional_seconds_precision)]] | INTERVAL SECOND [ ( precision [, fractional_seconds_precision ] ) | PERIOD (DATE) | PERIOD ( { TIME | TIMESTAMP } [(precision)] [WITH TIME ZONE] ) | REAL | DOUBLE PRECISION | FLOAT [ (integer) ] | NUMBER [ ( { integer | *} [, integer]... ) ] | { DECIMAL | NUMERIC } [ ( integer [, integer]... ) ] | { CHAR | BYTE | GRAPHIC } [ (integer) ] | { VARCHAR | CHAR VARYING | VARBYTE | VARGRAPHIC } [ (integer) ] | LONG VARCHAR | LONG VARGRAPHIC | { BINARY LARGE OBJECT | BLOB | CHARACTER LARGE OBJECT | CLOB } ( integer [ G | K | M ] ) | { XML | XMLTYPE } | JSON [ ( integer ) ] [ CHARACTER SET { UNICODE | LATIN } ] | [SYSUDTLIB.] { UDT_name | ST_Geometry | MBR | ARRAY_name | VARRAY_name } }- item_list
{ F delimiter method_entry_name | D | { S | C } S_or_C_item }- S_or_C_item
{ I delimiter name_on_server delimiter include_name | L delimiter library_name | O delimiter name_on_server delimiter object_name | S delimiter name_on_server delimiter source_name }