Skip to Main Content
Return to Navigation

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.

Insert Data Set Content 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.

    See Creating and Editing Data Set Definition.

  • 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 .

Operation

Select the operation to use for this field. Valid operations are:

  • != (not equal)

  • < (less than)

  • <= (less than or equal)

  • = (equal)

  • > (greater than)

  • >= (greater than or equal)

  • All

  • Between

  • In

  • Like (Value contains specified text)

Values

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.

See Using Operators to Build the WHERE Clause.

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.

Numeric Operators

For any of the numeric operators, select the operator and provide a value.

Image: Example Equal criteria

This example illustrates using the Equal operation.

Example equal criteria

Between

The Between operator expects an AND keyword in the values field.

Image: Example Between criteria

This example illustrates using the Between operation.

Example Between criteria

In

In interprets the , (comma) as the separator for the literals.

Image: Example In criteria

This example illustrates using the In operation.

Example In criteria

Like

Like will implicitly add % (percent sign) with the string.

Image: Example Like criteria

This example illustrates using the Like operation.

Example Like criteria