Skip to main content

CreateSqlSysDatatype

Create a SQL system datatype definition in the [SqlSysDatatypes] section of the CPF.

Synopsis

[Actions]
CreateSqlSysDatatype:Name=DatatypeName,Datatype=datatype

Description

CreateSqlSysDatatype defines a SQL system datatype. InterSystems IRIS® creates that SQL system datatype when processing the [Actions] section during a configuration merge. During the merge, InterSystems IRIS runs Config.SqlSysDatatypes.Create()Opens in a new tab to create the SQL system datatype defined by CreateSqlSysDatatype. 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 CreateSqlSysDatatype operation in the configuration merge file:

[Actions]
CreateSqlSysDatatype:Name=BigInt,Datatype=%Library.BigInt

Changing this Operation

This operation is designed to be used during a configuration merge. You can change CreateSqlSysDatatype 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