IBM Books

SQL Reference

User-defined Type Assignments

With user-defined types, different rules are applied for assignments to host variables than are used for all other assignments.

Assignment to host variables is done based on the source type of the distinct type. That is, it follows the rule:

A value of a distinct type on the right hand side of an assignment is assignable to a host variable on the left hand side if and only if the source type of this distinct type is assignable to this host variable.

If the target of the assignment is a column, the source data type must be castable to the target data type as described in Casting Between Data Types for user-defined types.


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]

[ DB2 List of Books | Search the DB2 Books ]