SQL Statements

In Service Definer, a SQL statement expresses a data retrieval or data manipulation action to be executed on behalf of a service caller by the underlying USoft Rules Engine.

Valid SQL statements include all SELECT, INSERT, UPDATE, DELETE and INVOKE statements that the Rules Engine accepts to handle. SELECT, INSERT, UPDATE, DELETE statements must operate on one of the Tables or Logical Views declared in the underlying USoft model. INVOKE must operate on one of the RDMI (= Rules-Driven Method Invocation) components declared as part of the underlying USoft model.

You can have the USoft Service Definer generate practically all the Java code that you need to make many typical REST services work. For this, you do not need any Java programming skills.

Each statement in USoft Service Definer is part of a specific Application.

See Also

Applications and connections

Generating REST Services from SQL