SQL expressions

Previous Next

USoft Blend  >  Expressions  >  SQL

 

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 ...

 

 

See also

Guide to expressions and data types

          Literal expressions

                  Dates

                  string literals

          Path expressions

          XML expressions

          XPath expressions

                  Node set expressions

                  Booleans

                  Strings

                  Numbers

                  Function calls

                  Variable references

                  Evaluated expressions vs. literals

         SQL expressions