SQL expressions

In contexts where SQL is expected, the USoft Blend framework processes full SQL statements.

USoft-supported SQL syntax

This type of SQL runs in a USoft context and is portable across database platforms. See USoft Definer Help for details of SQL syntax supported by the USoft Rules Engine.

Data type	Explanation	Examples
sql-statement	A SQL statement with a syntax supported by USoft that starts with one of the keywords SELECT, INVOKE, INSERT, UPDATE, DELETE.	SELECT DESTINATION, TOUR_TYPE FROM TOUR UPDATE TOUR SET MAX_AGE = 80 WHERE DESTINATION = 'AUSTRALIA' INVOKE batchrunner.DELETE_ACCOUNT WITH SELECT '221' "ACCOUNT_NUMBER"
select-statement	A SQL statement with a syntax supported by USoft that starts with the SELECT keyword. Subsets sql-statement.	SELECT DESTINATION, TOUR_TYPE FROM TOUR
dml-statement	A SQL statement with a syntax supported by USoft that starts with one of the keywords INSERT, UPDATE, DELETE. Subsets sql-statement.	UPDATE TOUR SET MAX_AGE = 80 WHERE DESTINATION = 'AUSTRALIA'

RDBMS-supported SQL syntax

This type of SQL is dependent on the database platform. See the database vendor's documentation for details of SQL syntax supported by the RDBMS.

Data type	Explanation	Examples
rdbms-ddl-statement	A SQL statement with a syntax supported by the RDBMS that starts with one of the keywords CREATE, ALTER, DROP.	ALTER TABLE TOUR ...
rdbms-ddl-dml-statement	Either an rdbms‑ddl‑statement or an rdbms‑dml‑statement	ALTER TABLE TOUR ... UPDATE TOUR ...
rdbms-dml-statement	A SQL statement with a syntax supported by the RDBMS that starts with one of the keywords INSERT, UPDATE, DELETE.	UPDATE TOUR ...
rdbms-query	A SQL statement with a syntax supported by the RDBMS that starts with the SELECT keyword.	SELECT ... FROM TOUR ...