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	`AND` `and` `+` (plus symbol) `&` (ampersand)	`cat AND dog` `"cat food"+milk` `"cat food"&"dog food"`
Either word in a topic	`OR` `or` `\|` (pipe)	`cat OR dog` `cat \| dog`
Topics that do not contain a specific word or phrase	`NOT` `not` `!` (exclamation point)	`NOT cat` `! dog`
Topics that contain one string and do not contain another	`^` (caret)	`cat ^ mouse`
A combination of search types	`( )` parentheses	`cat + (dog \| mouse)` `cat \| dog + (! mouse)`

Service Management2017.11

Administer > Database administration > Data persistence > Exporting records > Unload a database dictionary only

Unload a database dictionary only

Applies to User Roles:

System Administrator

To unload a database dictionary only:

Click Tailoring > Database Manager.
Type the form or file name that contains the records to unload.
Select the Administration Mode option. You must select this option to ensure that ITSMA Service Management displays the unload options in the target form.
Click Search.
Select the form to use to search for records. Do not type or select any search criteria from this form.
Click More or the More Actions icon, and then select Export/Unload.
Click Unl Dbdict.

Fill in the following fields.

Field	Description
External File Name	Type the name and path of the file used to save the record list. By default, this file is located in the RUN folder of the Service Management server.
Member	This field is obsolete
Unload Type	Select the operating system file type for the external file.
Append to File	Select this option to add records to the end of an external file of the same name. If a external file of the same name does not exist, Service Management creates a new file. If this field is cleared, then Service Management overwrites any existing file of the same name.
Use Data Map	Select this option to use a pre-defined data map when unloading the selected records. Using a data map may result in Service Management unloading more records than you originally selected to unload.
Prompt for Data Map	Select this option to enable a confirmation message to use a data map for each record unloaded. This option is only valid if the Use Data Map option is also enabled.
Suppress Messages	Select this option to hide all messages that the unload process generates.
Export Mode — Binary	Select this option to save the external file in Service Management’s binary unload format. Only the Service Management Database Manager can read this binary file format.
Export Mode — Text	Select this option to save the external file in Service Management’s text format. This format is human readable but is not intended for export to other applications other than Service Management’s Database Manager.
Export Mode — Formatted Text	Select this option to save the external file in a user-defined text format. This format is intended for export to other applications. If you select this option, you must type a valid Service Management form name in the Form Name field.
Form Name	Type the name of the Service Management form to use when exporting records as formatted text. This option is only valid with the Formatted Text option is selected. If the text format description does not already exist, Service Management prompts you to create it.
Dbdict Load Options — Create file if not there, and update if present	Select this option if the data saved in this external file should replace existing data in the target Service Management system.
Dbdict Load Options — Create file if not there, but do not update if present	Select this option to ignore data saved in the external file that already exists in the target Service Management system.
Dbdict Load Options — Create file if not there, and update if present, including keys	Select this option if the data saved in this external file should replace existing data in the target Service Management system including the database keys.
Dbdict Load Options — Create file if not there, and update if present, including SQL mapping	Select this option if the data saved in this external file should replace existing data in the target Service Management system including the database SQL mapping.
Dbdict Load Options — Create file if not there, and update if present, including keys AND SQL mapping	Select this option if the data saved in this external file should replace existing data in the target Service Management system including the database SQL mapping and the database keys.
Record Load Options — Add/update record	Select this option if the records saved in this external file are to replace any existing records in the target Service Management system.
Record Load Options — Only add new records	Select this option to ignore records saved in the external file that already exist in the target Service Management system.

Click Unload/export.
Service Management saves the select records to an external file.

Send Help Center feedback