Skip to main content

CreateSqlUserDatatype

Create a SQL user datatype definition in the [SqlUserDatatypes] section of the CPF.

Synopsis

[Actions]
CreateSqlUserDatatype:Name=Name,Datatype=datatype

Description

CreateSqlUserDatatype defines a SQL user datatype. InterSystems IRIS® creates that SQL user datatype when processing the [Actions] section during a configuration merge. During the merge, InterSystems IRIS runs Config.SqlUserDatatypes.Create()Opens in a new tab to create the SQL user datatype defined by CreateSqlUserDatatype. The Name and Datatype properties are required; the complete list of properties is available in the class reference.

Example

The following example demonstrates how to use the CreateSqlUserDatatype operation in the configuration merge file:

[Actions]
CreateSqlUserDatatype:Name=BigNEWInt,Datatype=%Library.BigNEWInt

Changing this Operation

This operation is designed to be used during a configuration merge. You can change CreateSqlUserDatatype by editing the merge file in a text editor (as described in Editing the Active CPF).

See Datatypes (SQL) for more information on SQL datatypes.

FeedbackOpens in a new tab