Maximo Insights

This is an example of how to execute DML statements (insert / update / delete)

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.