This documentation applies to the 8.1 version of Remedy Action Request System, which is in "End of Version Support."

To view the latest version, select the version from the Product version menu.

Using SQL commands to shorten the Request ID field

This section contains information about:

Only administrators running BMC Remedy AR System with an SQL database can update existing request ID field values by directly accessing the SQL database. The syntax for direct access is different for each SQL database that BMC Remedy AR System supports.

To use the methods described in this section, you must be familiar with basic commands in the SQL command interface. SQL commands bypass BMC Remedy AR System completely. If you bypass BMC Remedy AR System, verify that all data is valid when you are finished.

Tip

Create a practice table in your database and practice the commands you will issue to make sure that you are issuing the correct commands. Make sure you back up your database or all the relevant tables.

Note

When you change the length of the Request ID field in a database table, all related database tables, such as status history tables (H Tables), and Attachment tables (B Tables and BC Tables) must also be updated.

Important

Stop BMC Remedy AR System before you attempt any database modifications.

Finding the name of the table

Before you can shorten the request ID field value, you must find the table holding the form being changed.

To find the table name

  1. Find the correct schema ID for the form with the following query:
    Select SchemaId, name from arschema order by 2
    This query returns a list of schema IDs and associated form names.
  2. Find the correct field ID with the following query. (The example assumes that the schema ID is 43.)
    Select FieldId, FieldName from field where SchemaId = 43
    This query returns a list of field IDs and associated field names.
  3. Use the schema ID, field ID, and information in the following table to construct the table name.




AR System table name constructs

Table name

Description

T schemaID

A table that contains the data in your form. A table named T43 indicates that 43 is the schema ID.

T schemaIDC fieldID

(Oracle only) A table that contains long text and diary data. For example, a table named T43C536870924 indicates that 43 is the schema ID and 536870924 is the field ID. In many cases, the form has more than one long text or diary field. This format is used for backward compatibility with forms created using BMC Remedy AR System versions prior to 4.5.

H schemaID

A table that contains the Status History information for your form. A table named H43 indicates that 43 is the schema ID. See the Database Reference Using relational databases with BMC Remedy AR System.

B schemaID

A table that contains a list of all the attachments and related information for each record in your form. A table named B43 indicates that 43 is the schema ID. See The attachment tables for a form.

B schemaIDC fieldID

A table that contains the actual Binary objects for attachment fields in your form. A table named B43C536870924 indicates that 43 is the schema ID and 536870924 is the field ID. In this example, the field ID for the attachment field is 536870924. In some cases, the form has more than one attachment field.



Note

For T schemaID and B schemaID tables, the request ID column of the table is always named C1. For the H schemaID, T schemaIDC fieldID, and B schemaIDC fieldID tables, the Entry ID column is equivalent to the C1 column.

This version of the documentation is no longer supported. However, the documentation is available for your convenience. You will not be able to leave comments.

Comments