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 Manager9.41

Develop > Tailoring > Links > Entity Relationship Diagram creation utility > Generate a DDL file

Generate a DDL file

Applies to User Roles:

System Administrator

Database administrators often rely on conceptual and physical data models to understand the relationships among tables, records, and data, and to produce reports. If you have administrative rights, you can customize the files and links used to create the component Database Definition Language (DDL) statements.

To generate DDL statements in a file using the Entity Relationship Diagram (ERD) Creation utility:

Click Tailoring > Tailoring Tools > ERD Create Records.
Determine the correct export mode for the DDL statements.
- Full mode: Creates one foreign key definition for each unique field or file relationship. You can have multiple links between two files.
- Simple mode: Creates one foreign key definition for each file-to-file relationship within each relationship type.
From the ERD Creator Definition form, click the More Actions menu.
Select one of the following:
- Create/Export DDL > Full.
- Create/Export DDL > Simple.

The output of the ERD Create utility automatically resides at the root level of the Service Manager client installation folder. The file name is the DDL file name with a .sql file extension.

Example: ..\Program Files\HP\ Service Manager x.xx\ Service Manager Client\ddl_name.sql.

Send Help Center feedback