This is an example of how to execute DML statements (insert / update / delete)
Contents
hide
JDBC Connection
from psdi.security import UserInfo
from psdi.server import MXServer
vsql = "update po set vendor='ACME' where poid=9983"
mxserver = MXServer.getMXServer()
conKey = mxserver.getSystemUserInfo().getConnectionKey()
cnx = mxserver.getDBManager().getConnection(conKey)
stmt = cnx.createStatement()
stmt.executeUpdate(vsql)
stmt.close()
cnx.commit()
mxserver.getDBManager().freeConnection(conKey)
DBShortcut class
from psdi.mbo import DBShortcut, SqlFormat
from psdi.server import MXServer
vsql = "update po set vendor='ACME' where poid=9983"
mxserver = MXServer.getMXServer()
conKey = mxserver.getSystemUserInfo().getConnectionKey()
dbs = DBShortcut()
dbs.connect(conKey)
sqf = SqlFormat(vsql)
dbs.execute(1, sqf)
dbs.commit()
dbs.close()
Note: Avoid SQL execution on Maximo database objects, because it can cause data inconsistency.
If you found my post interesting or useful and just want to say thanks, you can always buy me a coffee.
