Supported SQL

An external program that accesses the database of a USoft business application must define its data needs in standard SQL. The SQL statements that can be used are:

•SELECT

•INSERT

•UPDATE

•DELETE

•INVOKE

Data definition statements such as CREATE, ALTER, and DROP are not supported, nor are the authorization statements GRANT and REVOKE. Use the USoft Developer's Create Application Tables function instead.