This content has been marked as final. Show 3 replies
If you can modify the KM thats fine else create one package.
Put one procedure prior to the interface. In the procedure use one update statement to update the target table and set the current_flg to 'N".
Net run the interface using sql control append. ( Inside interface you must have set the current_flg to 'Y')
So what ever record will be inserted, flag value will be set to Y.
I prefer not to use a procedure if possible.
How would I go about editing the KM ?
Edited by: 927304 on 28/01/2013 21:30
then put the update code prior to the insert new rows in IKM sql control append.