AIOps

AIOps

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.


#ITAutomation
#AIOps
#CloudPakforAIOps
#AIOps

 View Only
Expand all | Collapse all

How to get SQL command embedded in RPG to run quicker?

  • 1.  How to get SQL command embedded in RPG to run quicker?

    Posted Mon June 19, 2017 10:53 AM

    I have a SQL statement that selects data from a join and inserts it into a file. When I run it interactively it works quickly, however, when I use the same SQL command embedded in RPG it takes much longer to run...Any ideas why it does this?



  • 2.  RE: How to get SQL command embedded in RPG to run quicker?

    Posted Fri October 06, 2017 06:31 PM

    Can you clarify what product you are running the SQL command against?