Class Name |
Holds |
Notes |
%BigIntOpens in a new tab |
A 64–bit integer |
This class is similar to %IntegerOpens in a new tab except for its OdbcType and ClientDataType. |
%BinaryOpens in a new tab |
Binary data |
The actual binary data is sent to and from the client without any Unicode (or other) translations. |
%BooleanOpens in a new tab |
A boolean value |
The possible logical values are 0 (false) and 1 (true). |
%CharOpens in a new tab |
A fixed length character field |
|
%CounterOpens in a new tab |
An integer, meant for use as a unique counter |
Any property whose type class is %CounterOpens in a new tab will be assigned a value when a new object is saved or a new record is inserted via SQL, if no value is specified for that property. For details, see %CounterOpens in a new tab in the InterSystems Class Reference. |
%CurrencyOpens in a new tab |
A currency value |
This class is defined only for migrating from Sybase or SQL Server to InterSystems IRIS. |
%DateOpens in a new tab |
A date |
The logical value is in InterSystems IRIS $HOROLOG format. |
%DateTimeOpens in a new tab |
A date and time |
This class is used mainly for T-SQL migrations and maps datetime/smalldatetime behavior to the %TimeStampOpens in a new tab datatype. In this class, the DisplayToLogical() and OdbcToLogical() methods provide logic to handle imprecise datetime values that are supported by T-SQL applications. |
%DecimalOpens in a new tab |
A fixed point number |
The logical value is a decimal format number. See Numeric Computing in InterSystems Applications. |
%DoubleOpens in a new tab |
An IEEE floating-point number |
The logical value is an IEEE floating-point number. See Numeric Computing in InterSystems Applications. |
%EnumStringOpens in a new tab |
A string |
This is a specialized subclass of %StringOpens in a new tab that allows you to define an enumerated set of possible values (using the DISPLAYLIST and VALUELIST parameters). Unlike %StringOpens in a new tab, the display values for this property are used when columns of this type are queried via ODBC. |
%ExactStringOpens in a new tab |
A string |
A subclass of %StringOpens in a new tab with the EXACT default collation. |
%IntegerOpens in a new tab |
An integer |
|
%ListOpens in a new tab |
Data in $List format |
The logical value is data in $List format. |
%ListOfBinaryOpens in a new tab |
Data in $List format, with each list item as binary data |
The logical value is data in $List format. |
%NameOpens in a new tab |
A name in the form “Lastname,Firstname” |
The %NameOpens in a new tab data type has special indexing support when used in conjunction with the %Storage.Persistent class. For details, see %NameOpens in a new tab in the InterSystems Class Reference. |
%NumericOpens in a new tab |
A fixed-point number |
|
%PosixTimeOpens in a new tab |
A value for a time and date |
The logical value of this data type is the number of seconds since (or before) January 1, 1970 00:00:00, encoded as a 64-bit integer. %PosixTimeOpens in a new tab uses less disk space and memory than %TimeStampOpens in a new tab data type, and is better for performance than %TimeStampOpens in a new tab. |
%SmallIntOpens in a new tab |
A small integer value |
This class is the same as %IntegerOpens in a new tab except for its OdbcType. |
%StatusOpens in a new tab |
An error status code |
Many methods in the InterSystems IRIS Class Library return values of type %StatusOpens in a new tab. For information on working with these values, see %StatusOpens in a new tab in the InterSystems Class Reference. |
%StringOpens in a new tab |
A string |
|
%TimeOpens in a new tab |
A time value |
The logical value is the number of seconds past midnight. |
%TimeStampOpens in a new tab |
A value for a time and date |
The logical value of the %TimeStampOpens in a new tab data type is in YYYY-MM-DD HH:MM:SS.nnnnnnnnn format. Note that if h is a date/time value in $H format, then you can use the $ZDATETIME as follows to obtain a valid logical value for a %TimeStampOpens in a new tab property: $ZDATETIME(h,3)
Also see the comments for %PosixTimeOpens in a new tab. |
%TinyIntOpens in a new tab |
A very small integer value |
This class is the same as %IntegerOpens in a new tab except for its OdbcType and its maximum and minimum values. |