SQL queries (OP)

In an on-premises environment, you can define stand-alone SQL queries to extract information from the database and present this information in a report or chart. These stand-alone queries are not embedded in any other software component and are executed independently.

Note: The functionality to define and run stand-alone SQL queries is not available in a cloud environment.

Stand-alone queries can only read data from the database. A stand-alone query cannot add, delete, or update records in the database.

Note: You can also create queries in 4GL scripts or libraries. These queries can read and update data in the database. See the Infor ES Programmers Guide (Infor Customer Portal KB2924522).

You can create stand-alone queries with Easy SQL or with the Text Manager. Easy SQL helps users to define queries in a simple, menu-driven way. Text Manager enables you to create more complex queries.

You can run stand-alone queries in these ways:

  • Through the Query Data (ttadv3580m000) session. This session is not available in a cloud environment.
  • Through the Execute Query (ttadv3280m000) session. This session is not available in a cloud environment.
  • From a menu. You must first add the query, as a menu field of type "Query", to a menu.