1 person found this helpful
What is the error you are getting, that might help with the analysis of what's going wrong. Also which event are you executing this script in? However, straight away I can see from your code that youe are passing the LOADID as a parameter to the query but then not actually referencing that parameter in the UPDATE statement. That could be the casue of your issue (and even if it isn't you will want to rectify that oversight) but like I said we would need to see the generated error to be certain
in addition to LOADID issue, next time you say it fails, include at least the error :-)
1) print command won't have any result in your logs
2) you are trying to set VALID_FLAG to I in TDATASEG_T. In which event script? I say that because this column might be updated when mapping process happens (I did not test but I guess it can happen)
Hi Francisco yes you are right, sorry I forget to add more information because the issue was solved by someone else.
please can you close this thread then?