Inserting Data Content
Use the Insert Data Content page (PTADSDMWCONTENTSCH) to insert data content into the Data Migration project.
Image: Insert Data Set Content page
This example illustrates the fields and controls on the Insert Data Set Content page. You can find definitions for the fields and controls later on this page.
- Field Name
There are two types of fields in the grid.
Read-only: These are the key fields of the record selected while defining the data set definition. These fields can not be removed.
Non Key: You can add any other non key fields of root record of the data set definition. This addition is not in the data set definition, it is specific to this data set content in this specific data migration project .
Select the operation to use for this field. Valid operations are:
!= (not equal)
< (less than)
<= (less than or equal)
> (greater than)
>= (greater than or equal)
Like (Value contains specified text)
Enter the value for the SQL.
For every operation other than All you need to supply one or more values in this text box. Based on the operator and value, the system will build the actual WHERE clause for the filter condition on the root record of the data set definition.
- Search button
Click the Search button to display the rows meeting the filter criteria and display them on the Search Results grid.
- Search Results Grid
Use the Search Results grid to select the rows of data to include in the data set content.
- Select All
Use the Select All button to select all rows.
- Un-select All
Use the Un-select All button to unselect all rows.
- Insert button
Click the Insert button to insert the selected rows into the data set content and remain on the page.
- Insert and Return
Click the Insert button to insert the selected rows into the data set content and return to the Data Set Content page.
Using Operators to Build the WHERE Clause
This section provides examples for building WHERE Clauses.
For any of the numeric operators, select the operator and provide a value.
Image: Example Equal criteria
This example illustrates using the Equal operation.
The Between operator expects an AND keyword in the values field.
Image: Example Between criteria
This example illustrates using the Between operation.
In interprets the , (comma) as the separator for the literals.
Image: Example In criteria
This example illustrates using the In operation.
Like will implicitly add % (percent sign) with the string.
Image: Example Like criteria
This example illustrates using the Like operation.