This documentation supports the 9.0 version of Remedy Action Request System.

To view the latest 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:


Beginning with release 7.6.02, 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

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

Real

number

Decimal

date

Date/Time (default), Date, Time

blob

Attachment field in attachment pool

 

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

Comments