How to launch SQL Request in Sage Enterprise Management

As you know, Sage Enterprise Management provides its own select, update statements like SQL. For efficiency, we can use SQL queries in Sage X3. Sage X3 provides special function to execute SQL statements/ commands. The special function is Execsql. It is used to launch a SQL request that does not require the return of information, unlike the instruction For…From…Sql that recovers the columns.  This instruction is used, for example, to launch a Sql grant command that is used to accord the rights to a table. Syntax: Execsql From type_base Sql sql_exp Where, type_base :  A lphanumeric character describing the database type. sql_exp : Character... Read the full text.
Anonymous