SQL queries (OP)In an on-premises environment, you can define and run stand-alone SQL queries. You can use these 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 run independently. Nota 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. Nota You can also create queries in 4GL scripts or libraries. These queries can read and update data in the database. See the Infor ES Programmer's Guide. 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:
| |||