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.
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. |
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 |
|
- Database dictionary
- Database dictionary records
- Making database dictionary changes
- Database dictionary data types
- Alias fields
- Access the database dictionary utility
- Enable DDL logging of database dictionary changes
- Open a database dictionary
- Copying a database dictionary
- Methods for adding database dictionary records
- Methods for deleting database dictionary records
- Methods for updating database dictionary records
- Resetting a database table
Resetting a database table
In some scenarios, you may need to reset a database table to remove all records. For example, when moving a table from a development environment to a production environment, you may want to start with an empty production table. You may also need to limit the size of files that continually increase in size, such as syslog or msglog.
Warning: Use caution when choosing this option, as resetting removes all records from the table.
Resetting the database and all records
If the records in a dictionary are no longer needed but the file structure is to be retained for later use, perform a file reset.
The Reset option deletes all data records from a dictionary. In most instances, once a system is set up and is in operation, this option is not used. Most often it is utilized when clearing test data from a preimplemented system or test file.
Warning: You should only use this option when you intend to permanently remove data file records. Once a reset is performed, the records cannot be retrieved.
Reset a database table from Database Manager
Applies to User Roles:
System Administrator
In this example we reset the syslog table. Resetting other tables works the same way.
To reset a database table from Database Manager:
- Open the syslog form in Database Manager.
- Click More or the More Actions icon.
- Select Reset.
Service Manager displays a prompt, asking you to confirm the action and allowing you to schedule the Reset. - From the prompt, you can:
- Click OK to reset the syslog table.
- Click Cancel to leave the table intact and return to the blank syslog format.
- Click Schedule to schedule a time to run the file reset operation, either once or repeatedly at a set interval.
Schedule a reset
Applies to User Roles:
System Administrator
If you chose to schedule a reset by clicking the Schedule button on the reset prompt you are prompted with a schedule dialog, Service Manager displays a schedule form.
To schedule a reset:
- Provide a date in a DD/MM/YYYY format in the Date/Time to run field.
- Provide a time in an HH:MM:SS format the Date/Time to run field.
- Select a Repeat Interval option to reset the file on a regular basis.
This setting is optional.
The interval period starts from the time and date set in steps 2 and 3.
- Monthly – reset once a month.
- Quarterly – reset every three months.
- Semi-annually – reset every six months.
- Annually – reset once a year.
- Other – reset in the specified number of days, at the specified time.
Use the dd hh:mm:ss format, where dd is the number of days from the initial date and time, and hh:mm:ss is the time of day. For example, 26 10:00:00 schedules the reset to run at 10 a.m., 26 days from the initial reset date and time set in the Date/Time to run field.
- Click Schedule to confirm the reset action.
Related topics