System Datatypes
Synopsis
[SqlSysDatatypes] x=a
x is the name of an SQL datatype. a is the InterSystems IRIS equivalent.
Description
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.
Example
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
Changing 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).
See Also
User Datatypes entry in this book.
“Data Types” in InterSystems SQL Reference.