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. For hints about how to run the SQL interface and find the name of the table to be changed, see Using-SQL-commands-to-shorten-the-Request-ID-field.

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' as shown in the following example: 

*% update T43 set C1 = 'ABC00' + C1*

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*