SYSCASTS (IDS)

Home | Previous Page | Next Page System Catalog Tables >

SYSCASTS (IDS)

The syscasts system catalog table describes the casts in the database. It contains one row for each built-in cast, each implicit cast, and each explicit cast that a user defines. The syscasts table has the following columns.

Column	Type	Explanation
owner	CHAR(32)	Owner of cast (user informix for built-in casts and user name for implicit and explicit casts)
argument_type	SMALLINT	Source data type on which the cast operates
argument_xid	INTEGER	Code for the source data type specified in the argument_type column
result_type	SMALLINT	Code for the data type returned by the cast
result_xid	INTEGER	Data type code of the data type named in the result_type column
routine_name	VARCHAR(128)	Function or procedure implementing the cast
routine_owner	CHAR(32)	Name of owner of the function or procedure specified in the routine_name column
class	CHAR(1)	Type of cast: E = Explicit cast I = Implicit cast S = Built-in cast

If routine_name and routine_owner have NULL values, this indicates that the cast is defined without a routine. This can occur if both of the data types specified in the argument_type and result_type columns have the same length and alignment, and are passed by reference, or passed by value.

A composite index on columns argument_type, argument_xid, result_type, and result_xid allows only unique values. A composite index on columns result_type and result_xid allows duplicate values.