Skip to main content

This is documentation for Caché and Ensemble. See the InterSystems IRIS version of this content.Opens in a new tab

Please read this important announcement about the future of Caché and Ensemble maintenanceOpens in a new tab. Contact your account team to migrate to InterSystems IRIS.

User-Defined SQL Datatypes

Map SQL datatypes to their Caché equivalents.

Synopsis

[SqlUserDatatypes]    x=a

Description

The [SqlUserDatatypes] section contains a user-defined datatype descriptions. Each description maps an SQL datatype to its Caché 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 Caché equivalent, including any constraints on the arguments.

Examples

With the following line in the CPF file, when MYVARCHAR(10) is seen in a statement, the property is created with type %Library.String(MAXLEN=10,TRUNCATE=0). 

MYVARCHAR(%1)=%Library.String(MAXLEN=%1,TRUNCATE=0)
Range of Values

As described above.

Management Portal

On the page System Administration > Configuration > SQL and Object Settings > User-defined DDL Mappings, select Create New User-defined DDL Mapping or Edit to modify list of mappings.


FeedbackOpens in a new tab