ODBCFace can execute any SQL statement according with the level of OLE DB driver and DBMS or XML database.
Therefore you can select, insert, update or retrieve information.
Not only, you can also use any other SQL instructions of common use. For example you can use a statement like "SQL=Use MyCatalog" to change current catalog before performing a select.
In one of the example provided with ODBCFace we have also used a special extension of the IBM DB2/400 driver to actually submit a batch job for execution after uploading expense reports (see the J. D. Edwards Expense Report sample).