Data Migration Job - Method List Tab¶
Add, modify or remove methods you want to execute during your migration job. By method, we mean standard IFS New__ and Modify__ procedures stored in Logical Units in the database. You may also use user-defined methods or start other job entries from this window. This window is only used for source migration jobs.
Prefix Option: The column, Column Name in the mapping tab will be prefixed according to value in PrefixOption if the column is not a key column:
| Sequence | View Name | Prefix Option | View Column | Column Name in Mapping tab | Comment |
|---|---|---|---|---|---|
| 10 | SALES_PART | NoPrefix | DESCRIPTION | DESCRIPTION | No prefix. Column names will not be repeated in the Mapping tab |
| 10 | SALES_PART | ViewName | DESCRIPTION | SALES_PART.DESCRIPTION | Prefix with a view name. If DESCRIPTION occurs in other methods, but with different view names, it will occur once per view name. Note that key columns will not be prefixed, thus only occur once in the Mapping tab. |
| 10 | SALES_PART SALES_PART10 |
ViewNameUnique |
DESCRIPTION |
SALES_PART10.DESCRIPTION |
View name will be concatenated with execute_seq to make unique occurrences of all columns. View name in MethodList will be refreshed with new value after insert. This Prefix Option is useful if you need to run the same method more than once, but with different column values. For example, CUSTOMER_INFO_COMM_METHOD where you may insert rows for both Fax and Phone. |
Method Name: Here are some examples of available combinations:
| View Name | Action | Method Name | Comment |
|---|---|---|---|
| BeforeLoop | Intface_Header_API.Start_Job | This will start another job before the main loop in this job is executed. To specify the name of the job to be started, you must use RMB 'Method List Attribute..' and enter the Job ID in column 'FixedValue' for column INTFACE_NAME. This method does not return info about success or failure, and the main job will continue even if an error occurred on the first job. | |
| BeforeLoop | Intface_Header_API.Start_Job_From_Server | Setup is the same as above. This procedure returns info about failure, and will stop any further processing if any errors occurred. | |
| BeforeLoop | Fa_Object_API.Post_Import_Trans__ | Post imported transactions before new imports to FIXASS, Values for IN-parameters must be entered manually from RMB 'Method List Attribute..' | |
| INVENTORY_PART | InLoop | Inventory_Part_API | Standard INSERT or UPDATE. If you only enter View Name and then perform COMMIT, you will by default get the name of the LU, but no methods specified in Method Name. In addition, both columns 'OnNew' and 'OnModify' will be checked. This will result in a standard New__ or Modify__ depending on whether the record exists or not. This will have the same effect as earlier definitions with 2 separate methods for Modify__ and New__. From RMB 'Method List Attribute..' you may choose which column should be present on the attribute string, or if they should have a fixed value. |
| InLoop | Inventory_Part_API.Modify_Purch_Leadtime | The IN-parameters of this method will be available under the folder 'Source Mapping', and you may assign values in the same manner as for other columns. | |
| InLoop | Customer_Order_Line_API.Remove__ | OOPS! Do you really want to delete rows? If you're serious about this, make sure you've mapped correct values to OBJID_/OBJVERSION_ and that your main select has a Where-clause that is consistent with your intentions !! | |
| AfterLoop | Intface_Header_API.Start_Job_From_Server | Same as BeforeLoop, but with a slight difference: If an error occurs on this job, it is the setting of Rule IGNOREXEERROR that decides whether the main job shall continue or not. |
Modify: Procedure interfaces:
| Action | Type of method | Attribute layout | Comments |
|---|---|---|---|
| InLoop | User-defined procedure | INFO^^ATTR1^^ATTR2 ^^ ATTR3 ^^ ATTR4 ^^ ATTR5 ^^ |
To a user-defined procedure inside the main loop, we always parse the complete attribute string from the SELECT. Since this attribute string may be longer than 2000 characters, which is limit for dynamic SQL, we must divide it into pieces of 2000 chars. Inside the user-defined procedure, first step must be to concatenate the 5 attribute-pieces back to a complete attribute string. User defined procedures inside loop must have these parameters: ( info_ IN OUT VARCHAR2, attr1_ IN VARCHAR2, attr2_ IN VARCHAR2, attr3_ IN VARCHAR2, attr4_ IN VARCHAR2, attr5_ IN VARCHAR2 ) Here the INFO- variable is used for error-messages. Code EXCEPTIONS at the end of your procedure and put the error message in the info_ variable, and it will be handled accordingly to rule IGNOREXEERROR. The attribute string should NOT be edited. |
| BeforeLoop/ AfterLoop |
Start another migration job (Intface_Header_API.Start_Job) | INFO^^INTFACE_NAME^^ | For a standard Data Migration Procedure, the parameter list is always ( info_ IN OUT VARCHAR2, intface_name_ IN VARCHAR2 ) You may only edit the attribute string to add value to an item, e.g. add the name of the migration job you want to execute |
| BeforeLoop/ AfterLoop |
Start a user-defined procedure | INFO^^INTFACE_NAME^^ | User-defined procedures must have the same parameter list as a standard procedure (see the previous step). Any value added to item INFO or INTFACE_NAME will be parsed on to the procedure. The INFO variable is not connected to any error-handling, but any return-value here will be added to main info-variable shown at end of the job. |
Column Value: Here are some examples:
| Column Value examples | Method will be executed only.. |
|---|---|
| Blank (no value) | .. when specified column IS NULL |
| % | .. when specified column IS NOT NULL (any value) |
| A% | .. when the value of a specified column starts with capital a |
| TRUE | .. when the value of specified column equals 'TRUE' |
Method List Attributes¶
For each method list, there are Method List Attributes which you can navigate using Method List Attributes button.
When entering a View Name in window Method List, all columns from that view will be inserted here, with description and flag information.
Also, if you enter a specific procedure name in column Method Name in the same window, all IN/OUT-parameters of that procedure will occur here.
Use this window to configure the attribute-string to be used in New/Modify-methods, or hardcode values for IN/OUT-parameters to procedure-calls. When hardcoding values, you may refer to values from previous steps in the parameter list. This is possible because we save the output attribute-string for each method in memory. If the method has OUT-variables, these will also be added to this attribute-string.