SPECIFIC METHOD REPLACE INSTANCE CONSTRUCTOR A a A a parametername AS LOCATOR

Specific method replace instance constructor a a a a

This preview shows page 640 - 644 out of 858 pages.

SPECIFIC METHOD REPLACE INSTANCE CONSTRUCTOR A a A a parameter_name ) ( AS LOCATOR FOR UDT_name specific_method_name METHOD data_type UDT_name method_name B
Image of page 640
Chapter 8: END LOGGING - SET TIME ZONE REPLACE METHOD SQL Data Definition Language Syntax and Examples 641 1101A535 INTEGER SMALLINT BIGINT ( integer ) FLOAT NUMERIC DECIMAL BYTEINT DATE REAL DOUBLE PRECISION ( integer ) Data Type WITH TIMEZONE ( fractional_seconds_precision ) , fractional_seconds_precision TIME TIMESTAMP TO MONTH ( precision ) ( precision ) ( precision ) INTERVAL YEAR INTERVAL MONTH TO HOUR INTERVAL DAY MINUTE SECOND INTERVAL HOUR INTERVAL MINUTE TO SECOND ) INTERVAL SECOND ( precision ) ( precision ) ( precision ) ( precision ) TO MINUTE SECOND ( fractional_seconds_precision ) ( fractional_seconds_precision ) ( fractional_seconds_precision ) PERIOD(TIMESTAMP WITH TIMEZONE PERIOD(TIME PERIOD(DATE) A B , integer
Image of page 641
Chapter 8: END LOGGING - SET TIME ZONE REPLACE METHOD 642 SQL Data Definition Language Syntax and Examples where: 1101A536 BINARY LARGE OBJECT ( ( integer BLOB G K M CHARACTER LARGE OBJECT CLOB UDT_name SYSUDTLIB. ST_Geometry MBR A B CHAR BYTE GRAPHIC LONG VARGRAPHIC VARCHAR CHAR VARYING VARBYTE VARGRAPHIC ( integer ) ( integer ) LONG VARCHAR Syntax element … Specifies … SPECIFIC METHOD [ SYSUDTLIB .] specific_method_name the specific name for the method. This clause is mandatory for overloaded method_name s, but otherwise optional and can only be specified once per method definition. Unlike method_name (see “METHOD [SYSUDTLIB.] method_name” later in this table), specific_method_name must be unique within SYSUDTLIB . This name is stored in DBC.TVM as the name of the UDM database object (see the CREATE FUNCTION “Function Identifiers” and “External Body Reference Clause” topics in SQL Data Definition Language Detailed Topics ). See the CREATE FUNCTION “Specific Function Name Clause” topic in SQL Data Definition Language Detailed Topics . INSTANCE that the object is an instance method. See the CREATE METHOD “About Methods” topic in SQL Data Definition Language Detailed Topics for information about instance methods. INSTANCE is the default. CONSTRUCTOR that the object is a constructor method. See the CREATE METHOD “About Methods” topic in SQL Data Definition Language Detailed Topics for information about constructor methods.
Image of page 642
Chapter 8: END LOGGING - SET TIME ZONE REPLACE METHOD SQL Data Definition Language Syntax and Examples 643 METHOD [ SYSUDTLIB .] method_name the calling name for the method. method_name must be unique within the SYSUDTLIB database. You cannot give a method the same name as an existing method or any other database object contained within the SYSUDTLIB database. See the CREATE METHOD “Naming Conventions: Avoiding Name Clashes Among UDFs, UDMs, and UDTs” topic in SQL Data Definition Language Detailed Topics for details.
Image of page 643
Image of page 644

You've reached the end of your free preview.

Want to read all 858 pages?

  • Fall '17
  • Sir Ahsan
  • SQL Data Definition

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture