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

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

Using SQL commands to lengthen the Request ID field value

The format for all the supported databases is the same for lengthening the Request ID field format as with shortening the Request ID field format. See Using SQL commands to shorten the Request ID field for hints about how to run the SQL interface and find the name of the table to be changed.

In the following examples, the length of the field is restored to 15 characters (the maximum) from the current 10 characters by adding 5 leading zeros to the value of the Request ID field and assigning the resulting 15-character string to the Request ID field. When you determine the name of the table (T43 in the example), issue one of the following commands at the prompt:

  • Oracle
*% update T43 set C1 = '00000' \|\| C1*
  • Microsoft SQL Server
*% update T43 set C1 = '00000' + C1*

To add a prefix, specify the prefix as part of the string to be added. For example, to expand to 15 characters and add a prefix of ABC, use 'ABC00' instead of '00000' in the preceding example.

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