版次注意事項


35.4 Chapter 12. Working with Complex Objects: User-Defined Structured Types

35.4.1 Inserting Structured Type Attributes Into Columns

The following rule applies to embedded static SQL statements: To insert an attribute of a user-defined structured type into a column that is of the same type as the attribute, enclose the host variable that represents the instance of the type in parentheses, and append the double-dot operator and attribute name to the closing parenthesis. For example, consider the following situation:

   - PERSON_T is a structured type that includes the attribute NAME 
     of type VARCHAR(30).
   - T1 is a table that includes a column C1 of type VARCHAR(30).
   - personhv is the host variable declared for type PERSON_T in the 
     programming language.

The proper syntax for inserting the NAME attribute into column C1 is:

   EXEC SQL INSERT INTO T1 (C1) VALUES ((:personhv)..NAME)


[ 頁面頂端 | 前一頁 | 下一頁 | 目錄 | 索引 ]