I'm trying to remove records from Routing Operations (and other tables) via a Migration Job, with an CSV file as input.
Normally i use the Remove__ method, based on an SQL statement on the table from which the records should be removed.
This Remove__ method however requires a value for the Objkey and ObjVersion attribute.
When using a CSV input, I can search for the Rowkey via the Function Get_Rowkey, but I cannot find a way to return the RowVersion based on either the Rowkey, or the other key values.
Or is there an other approach to solve this ?
Best answer by anmise
I'm trying to remove records from Routing Operations (and other tables) via a Migration Job, with an CSV file as input.
Normally i use the Remove__ method, based on an SQL statement on the table from which the records should be removed.
This Remove__ method however requires a value for the Objkey and ObjVersion attribute.
When using a CSV input, I can search for the Rowkey via the Function Get_Rowkey, but I cannot find a way to return the RowVersion based on either the Rowkey, or the other key values.
Or is there an other approach to solve this ?
Do you have data in the file to identify the unique routing lines? If so, can you join the IC Table (e.g. IC_ROUTING_FILE_TAB) with the routing view to find the values?
SELECT R.ROWVERSION, R.ROWID FROM IFSAPP.ROUTING R ,IC_ROUTING_FILE_TAB RF WHERE R.KEY_VALUE=RF.KEY_VALUE AND R.KEY_VALUE2=RF.KEY_VALUE2
I'm trying to remove records from Routing Operations (and other tables) via a Migration Job, with an CSV file as input.
Normally i use the Remove__ method, based on an SQL statement on the table from which the records should be removed.
This Remove__ method however requires a value for the Objkey and ObjVersion attribute.
When using a CSV input, I can search for the Rowkey via the Function Get_Rowkey, but I cannot find a way to return the RowVersion based on either the Rowkey, or the other key values.
Or is there an other approach to solve this ?
Do you have data in the file to identify the unique routing lines? If so, can you join the IC Table (e.g. IC_ROUTING_FILE_TAB) with the routing view to find the values?
SELECT R.ROWVERSION, R.ROWID FROM IFSAPP.ROUTING R ,IC_ROUTING_FILE_TAB RF WHERE R.KEY_VALUE=RF.KEY_VALUE AND R.KEY_VALUE2=RF.KEY_VALUE2
The imported CSV file is in the table IC_A10_ROUTING_OPER_FILE_TAB and contains all necessary values to identify unique lines.
Entering the Migration Job attributes:
on the Formatting tab Source Name : IC_A10_ROUTING_OPER_FILE_TAB A, IFSAPP.ROUTING_OPERATION B Where : b.CONTRACT=a.CONTRACT AND b.PART_NO=a.PART_NO AND b.ROUTING_REVISION=a.ROUTING_REVISION AND b.BOM_TYPE_DB=a.BOM_TYPE_DB AND b.OPERATION_NO=a.OPERATION_NO
On the Method tab Adding ROUTING_OPERATION_API.Remove__ as method
and on the Source Mapping tab: METHOD10_OBJID = B.OBJID METHOD10_OBJVERSION = B.OBJVERSION METHOD10_ACTION = 'DO' OBJID = B.ROWID
The imported CSV file is in the table IC_A10_ROUTING_OPER_FILE_TAB and contains all necessary values to identify unique lines.
Entering the Migration Job attributes:
on the Formatting tab Source Name : IC_A10_ROUTING_OPER_FILE_TAB A, IFSAPP.ROUTING_OPERATION B Where : b.CONTRACT=a.CONTRACT AND b.PART_NO=a.PART_NO AND b.ROUTING_REVISION=a.ROUTING_REVISION AND b.BOM_TYPE_DB=a.BOM_TYPE_DB AND b.OPERATION_NO=a.OPERATION_NO
On the Method tab Adding ROUTING_OPERATION_API.Remove__ as method
and on the Source Mapping tab: METHOD10_OBJID = B.OBJID METHOD10_OBJVERSION = B.OBJVERSION METHOD10_ACTION = 'DO' OBJID = B.ROWID
