Home
SQL programmingYou can use the HCL OneDB™ implementation of the SQL language to develop applications for HCL OneDB™ database servers.
Guide to SQL: SyntaxThe HCL OneDB™ Guide to SQL: Syntax describes the syntax of the statements, data types, expressions, operators, and built-in functions of the HCL OneDB™ dialect of the SQL language.
SQL statementsThis chapter describes the syntax and semantics of SQL statements that are recognized by HCL OneDB™.
CREATE CAST statementUse the CREATE CAST statement to register a cast that converts data from one data type to another.
Source and Target Data TypesThe CREATE CAST statement defines a cast that converts a source type to a target type. Both the source and target data types must exist in the database when you execute the CREATE CAST statement to register the cast.

Source and Target Data Types

The CREATE CAST statement defines a cast that converts a source type to a target type. Both the source and target data types must exist in the database when you execute the CREATE CAST statement to register the cast.

The source and the target data types have the following restrictions:

Either the source or the target type, but not both, can be a built-in data type.
Neither the source nor the target type can be a DISTINCT type of the other.
Neither the source nor the target types can be a COLLECTION data type.