Searching the Help
To search for information in the Help, type a word or phrase in the Search box. When you enter a group of words, OR is inferred. You can use Boolean operators to refine your search.
Results returned are case insensitive. However, results ranking takes case into account and assigns higher scores to case matches. Therefore, a search for "cats" followed by a search for "Cats" would return the same number of Help topics, but the order in which the topics are listed would be different.
Words and Phrases
| Search for | Example | Results |
|---|---|---|
| A single word | cat
|
Topics that contain the word "cat". You will also find its grammatical variations, such as "cats". |
|
A phrase. You can specify that the search results contain a specific phrase. |
"cat food" (quotation marks) |
Topics that contain the literal phrase "cat food" and all its grammatical variations. Without the quotation marks, the query is equivalent to specifying an OR operator, which finds topics with one of the individual words instead of the phrase. |
Using Boolean Operators
| Search for | Operator | Example |
|---|---|---|
|
Two or more words in the same topic |
|
|
| Either word in a topic |
|
|
| Topics that do not contain a specific word or phrase |
|
|
| Topics that contain one string and do not contain another | ^ (caret) |
cat ^ mouse
|
| A combination of search types | ( ) parentheses |
|
Running SQL Compare
The following SQL Compare files are included when you install the Service Manager Upgrade Utility:
- sqlupgrade.unl
- upgdbdct.dta
SQL Compare returns messages for dbdict mappings that contain new fields. You can update the dbdicts to contain the fields specified by the SQL Compare applications before you begin the applications upgrade.
Note Run SQL Compare on a development system. Do not run SQL Compare on the post-upgrade system.
Note
Before running SQL Compare, load the preupg.bin file using Service Manager Database Manager. See Step 4: Load the applications upgrade file for more information.
To run the SQL Compare utility, follow these steps:
- From the System Navigator, click System Administration > Ongoing Maintenance > Upgrade Utility > SQL Compare Utility.
- Select Run SQL Compare Utility, and then click Next.
-
Type the full path to upgdbdct.dta including the final back slash (\) or forward slash (/), depending on your operating system. For example, if you copied the files to a temporary directory, the path might be:
Windows:
c:\temp\upgrade\Linux: ~/upgrade/
Note You must have read, write, and execute permission to the folder.
-
Click the Next button.
SQL Compare returns the following message:
Process Complete. Please check for any additional messages.The results of the SQL Compare process are stored in the sqlupgrade table. This table resets each time you run SQL Compare.
To view the SQL compare results of the table fields, follow these steps:
- From the System Navigator, click System Administration > Ongoing Maintenance > Upgrade Utility > SQL Compare Utility.
- Select View SQL Field Compare Results, and then click Next.
- Click Search. The results are displayed in a record list.
Each table field difference found by the SQL Compare Utility appears as a separate record in the sqlupgradefield file. This record also lists the new fields that you must add to the database dictionary if you are updating your RDBMS mapped system manually.
The sqlupgradefield record provides the following information for each field you must add or modify if you are updating your RDBMS mapped system manually.
| Field | Description |
|---|---|
| File Name | The exact file name which delegates the database dictionary. |
| Field Name | The exact field name to add or modify to the associated database dictionary. |
| Field Structure | The field structure in the database dictionary. |
| Field Type | The field type in the database dictionary. |
| Field Level | The field level in the database dictionary. |
| Result Type | The actions happened or will happen to this field. |
| Field Alias Of |
If this is an alias field, it contains the name of the primary field that it is an alias of. Otherwise, this field is blank. |
| Field SQL Table Alias | The SQL table alias of this field in the database dictionary. |
| Field SQL Name | The SQL name of this field in the database dictionary. |
| Field SQL Type | The SQL type of this field in the database dictionary. |
| Field SQL RC | The encoding format of this field in the database dictionary. |
| Exceptions | The exceptions that occurs when adding or modifying this field. |
To view the SQL Compare results of the table unique keys, follow these steps:
- From the System Navigator, click System Administration > Ongoing Maintenance > Upgrade Utility > SQL Compare Utility.
- Select View SQL Unique Key Compare Results, and then click Next.
- Click Search. The results are displayed in a record list.
Each table unique key difference found by the SQL Compare Utility appears as a separate record in the sqlupgradekey file. This record also lists the new unique keys that you must add to the database dictionary, if you want to check the possible duplicated record manually.
The sqlupgradekey record provides the following information for each field you must add or modify, if you want to check the possible duplicated record manually.
| Field | Description |
|---|---|
| File Name | The exact file name which delegates the database dictionary. |
| Result Type | The actions happened or will happen to this field. |
| Key Type | The unique key types include primary, unique, and noduplicated. |
| Key Field | Concatenates all the key fields with the | character. |
| Exceptions | The exceptions that occurs when adding or modifying this unique key. |
