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
Making database dictionary changes
Before making database dictionary (dbdict) changes, consider the following behaviors and constraints.
A database dictionary (dbdict) update will fail if:
- A SQL data type is changed and it is not a change from CHAR to VARCHAR or from VARCHAR to CHAR (VARCHAR2 on Oracle).
- A SQL data type is changed and it is not a change from NCHAR to NVARCHAR or from NVARCHAR to NCHAR on Microsoft SQL Server or Oracle (NVARCHAR2).
-
A SQL data type is changed and it is a change from NCHAR to CHAR or from NVARCHAR to VARCHAR on Microsoft SQL Server.
- A SQL data type CHAR or VARCHAR is shortened.
- ALTER TABLE statements were generated but failed to execute.
A full table copy is triggered for any of the following conditions:
- The RC flag changes for any field.
- The alias changes for any field (but not from or to a NULLTABLE alias).
- A new table is defined for a dbdict.
- The SQL dbtype changed significantly. (For example, either from db2universal to sqlserver, or from one sqlserver2k to sqlserver IF those two SQL dbtypes use different sqldb or sqllogin parameter values.)
An ALTER TABLE statement will be generated to accomplish any of the following changes:
- A SQL data type changed from CHAR to VARCHAR, or vice versa (VARCHAR2 on Oracle).
- A SQL data type changed from NCHAR to NVARCHAR, or vice versa on Microsoft SQL Server.
-
A SQL data type changed from VARCHAR to NVARCHAR on Microsoft SQL Server.
- A SQL data type changed from NCHAR to NVARCHAR2, or vice versa on Oracle.
- A SQL data type changed from GRAPHIC to VARGRAPHIC, or vice versa on DB2.
- A SQL data type was widened (for example, from CHAR(10) to CHAR(15)).
- A SQL column was renamed.
- A table was renamed.
On DB2, certain ALTER TABLE operations require a REORG of the affected table. Service Manager executes these REORGs, if:
- An ALTER TABLE ... DROP COLUMN statement was executed.
- A SQL column was renamed.
- A SQL type was changed (but not if the change was only widening VARCHAR or VARGRAPHIC columns).
A DROP TABLE statement will be generated if a table entry was completely removed from the SQL Tables tab.
If Service Manager determines it does not have rights to CREATE a TABLE, it will assume not having the rights of performing any of the above operations. In that case it will write all database definition language (DDL) into files in the <RUN directory>/ddl folder and accept changes to the dbdict without performing any of the above operations. It will, however, still verify that the SQL type changes are valid.
Related topics
Methods for updating database dictionary records
Methods for deleting database dictionary records
Adding a key
Modifying a key
Deleting a key