Condition

Use the Condition tab to select source tables for mapping fields with target tables along with preconditions and main queries. You can use the Condition Builder to create a precondition.

You can use the Query Builder to create a main query. The documentation text can be maintained for a precondition and a main query.

Note

Use VB scripting syntax to define the conversion rules for migration from legacy to Baan or legacy to legacy.

Use the Infor Tools 3GL syntax to define the conversion rules for migration from one version to another.

Related topics

- Rules tab to open Conversion Object Detail page

Fields | Description
Source Tables | Displays the selected list of source tables. Note If the required source tables are not displayed, you cannot import the source tables as a part to source application of your working profile.
Precondition | Displays the defined preconditions, such as the conditions under which data comes from the selected source tables. Keyword migrate is introduced to indicate the source from which the data arrives. Precondition is the high-level plan of migration logic where you can initialize a variable, perform calculations for global variables, and select values in parameter tables of the source application that controls the migration logic. Note You can also use two key words of DCA, which have the following meanings: Migrate: Migrate <source table name>: Specifies that you want to extract data from this table and load the data in the target table. Dump: Dump <number>: Specifies that you want to write a record in the target table. Note If a comment is specified for the dump statement, the comment is displayed along with the dump number, in the Dump No. field of the Rules tab.
Source Table | Displays a list of migrate table name values, used in the precondition section earlier. For every use of migrate entered in the precondition; one entry is added to the Source Table list.
Main Query | Displays the main query. You can use clauses such as selectdo...endselect, if...else...endif. Apart from these select statements you can use only the keyword dump.

Commands | Description
Maximize | Maximizes the Precondition or Main Query window.
Minimize | Minimizes the Precondition or Main Query window.
Select | Selects the source tables in a separate window.
Build | Starts the condition/query builder in a separate window to create/edit a precondition/main query more easily. The Build button in the Precondition pane is not available for Legacy to Baan migration.
Editor | Edits the Precondition or Main Query text in the editor application mentioned at the user details level.
Text | Maintains the Precondition or Main Query documentation text in a separate window. The documentation is functional in nature and helps the implementation consultant and maintenance engineers.
Functions | Defines the functions that are used in the conversion rules. These functions are specific to the conversion object. The function is saved in the database only after you save the conversion object.
Variables/Includes | Declares/initializes Variables/Includes that are used in the conversion rules or functions. The Variables/Includes is saved in the database only after you save the conversion object.
Save | Saves the conversion rules. You must save the changes made, before you click the Rules tab to see the source table information maintained on the current tab.
Done | Click Done to return to the Maintain Conversion Objects page.
Cancel | Cancels the changes made and returns to the Maintain Conversion Object page.

| Send Us Your Feedback About this Help Page