System Datatypes

Synopsis

[SqlSysDatatypes]    x=a

Copy link to this sectionDescription

The [SqlSysDatatypes] section contains system-defined datatype descriptions. Each description maps an SQL datatype to its InterSystems IRIS equivalent in the format x=a, as follows:

• Each keyword x is the name of the SQL datatype, plus any allowed arguments.

• The value a is the InterSystems IRIS equivalent, including any constraints on the arguments.

Copy link to this sectionExample

The following excerpt of a configuration parameter file shows the [SqlSysDatatypes] which begin with the letter B. For a table of all System-Defined DDL Datatype mappings, see Table of DDL Data Types in the “Data Types” chapter of InterSystems SQL Reference.

[SqlSysDatatypes]
BIGINT=%Library.BigInt
BIGINT(%1)=%Library.BigInt
BINARY=%Library.Binary(MAXLEN=1)
BINARY VARYING=%Library.Binary(MAXLEN=1)
BINARY VARYING(%1)=%Library.Binary(MAXLEN=%1)
BINARY(%1)=%Library.Binary(MAXLEN=%1)
BIT=%Library.Boolean

Copy code to clipboard

Copy link to this sectionChanging This Parameter

On the System-defined DDL Mappings page of the Management Portal (System Administration > Configuration > SQL and Object Settings > System DDL Mappings), select Edit to modify a datatype definition.

Instead of using the Management Portal, you can modify datatype definitions by editing the CPF in a text editor (as described in the Editing the Active CPF section of the “Introduction to the Configuration Parameter File” chapter in this book).

Copy link to this sectionSee Also

• User Datatypes entry in this book.

• “Data Types” in InterSystems SQL Reference.