Hi,
Hope someone can help. If there is a missing api to make an update to a table (M3) is this possible to be done via sql or other method from an ion workflow ?
Thanks in advance for any ideas.
Hi, You might have found the answers. 1) If this is an interactive functionality you can create IPS(M3 web service) and use this via ion API. 2) Create a MI transaction using XtendM3 and perform an Update operation on the M3 tables using Database API.
Note this is for on-premise and a simple update / error correction for example.
Not sure about ION, but you can send a BOD to M3 and do SQL update in MEC as a workaround.
Although it's possible, please be aware that direct SQL updates to a table are not reflected by M3 in any sub-system(s) started before the updated was performed due to the way the system works.
in MT not possible.
in Cloud / ST is possible but not recommended.
in anothers versions is possible, not recommend but used many times...
Hi
Thanks for the suggestions. We used an extension table in the end for our requirement (cugex) instead of updating the tables but the suggestions could be useful in the future. Thanks
The problem is that CUGEX has size limitation on its column tables (eg. CUGEX3) with low performance.
You will need TXID (text tables) in some cases....
Thanks Antonio, that is good to know. Fortunately our requirement was limited so cugex was acceptable.
