Search

Discussion Thread 1

Timeout Error

Discussion Thread 4

Create XML Import to Enterprise Services

Discussion Thread 3

More Action "Process All" Not Showing in App

Answer

RE: How to read recordsets from remote Oracle DB using Automation script?

You will require to do something similar after changing Drive to Oracle and in between call PreparedStatement to execute SQL. You need to be careful when calling external DB and firing direct SQL with Maximo Framework. import java.sql.DriverManager as DriverManager import java.sql.SQLException...

Discussion Thread 3

Prevent Parent Work Order to status 'COMP' or 'CLOSE' with Open Children

Discussion Thread 5

Classifications

Discussion Thread 22

PM Scheduling

Question

How to read recordsets from remote Oracle DB using Automation script?

Hello! Is it possible to connect to remote third-party DB (Oracle) from Automation script directly and read some records?

Discussion Thread 1

Monitor Temperature & Humidity with ESP8266 and Maximo Monitor

Answer

RE: Most recent workflow transaction

Thank you for your answers Prashant and Danielle. I've tried what you have both suggested. It still returns me the latest record thats committed to the database. Not the Transid from the workflow transactions that are at that time being created. I have moved my logic to an escalation that will...