This documentation supports the 20.02 version of Remedy Action Request (AR) System.

To view an earlier version, select the version from the Product version menu.


Database data types for view forms

The following sections list the data types supported by each database for BMC Remedy AR System field types in view forms. Developer Studio automatically maps the field types to corresponding data types.

In this topic:


View forms support additional data types. This includes blobs (Oracle) and images (Microsoft SQL Server), which map to an attachment field, and several date and time data types, which map to the Date, Time, or Date/Time field types as shown in this section. (For view forms created in previous releases of AR System, Date/Time fields that were mapped to an integer column are still supported.)

In some cases, you can map a different field type to a column type if appropriate for the data. See Mapping an alternative AR System field type.

Note

When the data types nchar, nvarchar, or ntext are supported, they are used on Unicode servers, and the char, varchar, and text data types are used on non-Unicode servers.


For information about the database column types used for AR System fields in regular forms, see Database column types used for AR System fields.

SQL Server data type mappings for view forms

The following data types are supported for view forms based on a Microsoft SQL Server database table:

Microsoft SQL Server data types

AR System field types

nchar,char, varchar

Character (limited length)

ntext,text

Character (unlimited length)

int, tinyint, smallint

Integer, Date, Date/Time

real, float

Real

decimal

Decimal

datetime, smalldatetime

Date/Time (default), Date, Time

image

Attachment field in attachment pool


Oracle data type mappings for view forms

The following data types are supported for view forms based on an Oracle database table:

Oracle data types

AR System field types

varchar, varchar2, char, nchar

Character (limited length)

clob

Character (unlimited length)

number

Integer, float, Date, Date/Time

float

Real

date

Date/Time (default), Date, Time

blob

Attachment field in attachment pool


Was this page helpful? Yes No Submitting... Thank you

Comments