Common Property Parameters
This page provides reference information on common property parameters available for use in literal properties.
Introduction
Depending on the property, you can specify parameters of that property, to affect its behavior. For example, parameters can specify minimum and maximum values, formatting for use in display, collation, delimiters for use in specific scenarios, and so on. You can specify parameters within the class definition. The following shows an example:
Property MyProperty as %String (MAXLEN=500);
Note that many of these parameters act as constraints; the term constraint refers to any parameter that constrains the values of a property. For example, MAXVAL, MINVAL, DISPLAYLIST, VALUELIST, and PATTERN are all constraints.
Available Property Parameters, Listed by Data Type Class
You can use CALCSELECTIVITY, CAPTION, EXTERNALSQLNAME, EXTERNALSQLTYPE, JAVATYPE in all property definitions. You can use additional property parameters, depending on the data type class:
Common parameters: DISPLAYLIST, FORMAT, MAXVAL, MINVAL, VALUELIST
Parameters for XML and SOAP: XSDTYPE
Common parameters: MAXLEN, MINLEN
Parameters for XML and SOAP: CANONICALXML, MTOM, XSDTYPE
Parameters for XML and SOAP: XSDTYPE
Common parameters: COLLATION, CONTENT, DISPLAYLIST, ESCAPE, MAXLEN, MINLEN, PATTERN, TRUNCATE, VALUELIST
Parameters for XML and SOAP: XMLLISTPARAMETER, XSDTYPE
Common parameters: DISPLAYLIST, FORMAT, MAXVAL, MINVAL, VALUELIST
Parameters for XML and SOAP: XSDTYPE
Common parameters: DISPLAYLIST, FORMAT, MAXVAL, MINVAL, SCALE, VALUELIST
Parameters for XML and SOAP: XSDTYPE
Note: this special-purpose class is only for use in migrations to InterSystems IRIS.
Common parameters: DISPLAYLIST, FORMAT, MAXVAL, MINVAL, VALUELIST
Parameters for XML and SOAP: XSDTYPE
Common parameters: DISPLAYLIST, MAXVAL, MINVAL, VALUELIST
Parameters for XML and SOAP XMLDEFAULTVALUE, XMLTIMEZONE, XSDTYPE
Other parameters: DATEFORMAT
Common parameters: DISPLAYLIST, FORMAT, MAXVAL, MINVAL, SCALE, VALUELIST
Parameters for XML and SOAP: XSDTYPE
Common parameters: DISPLAYLIST, FORMAT, MAXVAL, MINVAL, SCALE, VALUELIST
Parameters for XML and SOAP: XSDTYPE
Common parameters: COLLATION, CONTENT, DISPLAYLIST, ESCAPE, MAXLEN, MINLEN, PATTERN, TRUNCATE, VALUELIST
Parameters for XML and SOAP: XSDTYPE
Common parameters: COLLATION, CONTENT, DISPLAYLIST, ESCAPE, MAXLEN, MINLEN, PATTERN, TRUNCATE, VALUELIST
Parameters for XML and SOAP: XSDLISTPARAMETER, XSDTYPE
Common parameters: DISPLAYLIST, FORMAT, MAXVAL, MINVAL, VALUELIST
Parameters for XML and SOAP: XSDTYPE
Other parameters: STRICT
Common parameters: ODBCDELIMITER
Parameters for XML and SOAP: XSDTYPE
Common parameters: ODBCDELIMITER
Parameters for XML and SOAP: XSDTYPE
Common parameters: COLLATION,MAXLEN
Parameters for XML and SOAP: XSDTYPE
Other parameters: INDEXSUBSCRIPTS
Common parameters: DISPLAYLIST, FORMAT, MAXVAL, MINVAL, SCALE, VALUELIST
Parameters for XML and SOAP: XSDTYPE
Common parameters: MAXVAL, MINVAL
Parameters for XML and SOAP XMLDEFAULTVALUE, XMLTIMEZONE, XSDTYPE
Other parameters: DATEFORMAT
Common parameters: DISPLAYLIST, FORMAT, MAXVAL, MINVAL, VALUELIST
Parameters for XML and SOAP: XSDTYPE
Parameters for XML and SOAP: XSDTYPE
Common parameters: COLLATION, CONTENT, DISPLAYLIST, ESCAPE, MAXLEN, MINLEN, PATTERN, TRUNCATE, VALUELIST
Parameters for XML and SOAP: XMLLISTPARAMETER, XSDTYPE
Common parameters: DISPLAYLIST, FORMAT, MAXVAL, MINVAL, VALUELIST
Parameters for XML and SOAP: XMLTIMEZONE, XSDTYPE
Other parameters: PRECISION
Common parameters: DISPLAYLIST, MAXVAL, MINVAL, VALUELIST
Parameters for XML and SOAP: XMLDEFAULTVALUE, XMLTIMEZONE, XSDTYPE
Common parameters: DISPLAYLIST, FORMAT, MAXVAL, MINVAL, VALUELIST
Parameters for XML and SOAP: XSDTYPE
Many data type classes also support INDEXNULLMARKER, which should almost never be overridden; it is described with the rest of the parameters in the next section.
Property Parameter Reference
This section provides reference information on the property parameters used by the most common data type classes, other than the ones that apply to XML and SOAP contexts.
Available for all properties. Controls whether the Tune Table facility calculates the selectivity for a property. Usually it is best to leave this parameter as the default (1). For details, see Tune Table.
Available for all properties. Caption to use for this property in client applications.
Specifies the manner in which property values are transformed for indexing.
The allowable values for collation are discussed in SQL Introduction.
Specifies the contents of the string, when the string is used in a context where it might be interpreted as XML or HTML. Specify "STRING" (the default), "ESCAPE", or "MIXED".
For details, see Controlling the Projection to XML Schemas.
-
For %DateTimeOpens in a new tab, this parameter specifies the order of the date parts when a numeric date format is specified for the display or ODBC input value. Valid parameters are mdy, dmy, ymd, ydm, myd, and dym. The default DATEFORMAT is mdy.
-
For %PosixTimeOpens in a new tab, this parameter specifies the format for the display value. For allowed values, see the fformat parameter of the $zdatetime and $zdatetimeh functions.
Used for enumerated (multiple-choice) properties, along with VALUELIST. For more information, see Defining Enumerated Properties.
Specifies the type of escaping to be done, if the string is used in certain contexts. Use either "XML" (the default) or "HTML".
By default, the less than, greater than, and ampersand characters are interpreted as < > and & respectively. For further details on "XML", see Controlling the Projection to XML Schemas.
Available for all properties. Used in linked tables, this parameter specifies the name of the field in the external table to which this property is linked. The Link Table wizard specifies this parameter for each property when it generates a class. The name of the SQL field on the remote database may need to differ from property name on the InterSystems IRIS server for various reason, such as because the remote database field name is a reserved word in InterSystems IRIS. For information on linked tables, see The Link Table Wizard.
Note that the property parameter EXTERNALSQLNAME has a different purpose than the SQLFieldName compiler keyword, and these items can have different values. SQLFieldName specifies the projected SQL field name in the InterSystems IRIS database, and EXTERNALSQLNAME is the field name in the remote database.
Available for all properties. Used in linked tables, this parameter specifies the SQL type of the field in the external table to which this property is linked. The Link Table wizard specifies this parameter for each property when it generates a class. See EXTERNALSQLNAME.
Specifies the format for the display value. For the value of FORMAT, use a format string as specified in the format argument of the $FNUMBER function. For properties of type %NumericOpens in a new tab or %DecimalOpens in a new tab, you can also use the option "AUTO", which suppresses any trailing zeroes.
Specifies the default null marker to use when a property of this type is used in a subscript of an index map. For default values of this parameter, see %Library.DataTypeOpens in a new tab and %Library.PosixTimeOpens in a new tab.
Do not override this parameter unless you have existing code setting these values into index globals directly and your application code is careful not to use those values in INSERT or SELECT statements.
For %NameOpens in a new tab. Specifies the number of subscripts used by the property in indexes, using a comma as a delimiter in the property value; the %Storage.Persistent class uses this number. A value of 2 specifies that the first comma piece of the property value is stored as the first subscript and the second comma piece of the property value is stored as the second subscript.
Available for all properties. The Java data type to which this property is projected.
Specifies the maximum number of characters the string can contain. The default is 50, and if this parameter is "", the length is unlimited. As with many other parameters, this parameter affects how InterSystems IRIS validates data. Note that it also affects how the field is projected over a database driver.
Specifies the maximum allowed logical value for the data type.
Specifies the minimum number of characters the string can contain.
Specifies the minimum allowed logical value for the data type.
Specifies the delimiter character used to construct a %List value when it is projected via ODBC.
Specifies a pattern that the string must match. The value of PATTERN must be a valid InterSystems IRIS pattern-matching expression. For an overview of pattern matching, see Pattern Matching.
For %TimeOpens in a new tab. Specifies the number of decimal places to retain. If the value is "" (the default), the system retains the number of decimal places that are provided in the source value. If the value is 0, InterSystems IRIS rounds the provided value to the nearest second.
Specifies the number of digits following the decimal point.
For %IntegerOpens in a new tab. Requires that value be an integer. By default, if a property is of type %IntegerOpens in a new tab, and you specify a non-integer numeric value, InterSystems IRIS converts the value to an integer. If STRICT is 1 for a property, in such a case, InterSystems IRIS does not convert the value; instead validation fails.
Specifies whether to truncate the string to MAXLEN characters, where 1 is TRUE and 0 is FALSE. This parameter is used by the Normalize() and IsValid() methods but is not used by database drivers.
Used for enumerated (multiple-choice) properties, along with DISPLAYLIST. For more information, see Defining Enumerated Properties.
The parameters that available for all properties are not defined in data type classes. The rest are defined within the data type classes that use them.