For more information and restrictions on these and other SQL statements, see your DBMS-specific SQL documentation. The following example grants UPDATE and INSERT authority to user TESTUSER on the ...

Analyze database contents using basic, intermediate and advanced SQL statement syntax and usage. Demonstrate capability to query data from multiple tables using SQL JOINS. Create and modify database ...

The value is returned through the macro variable SQLRC (a short form for SQL return code). For example, if a SELECT statement is valid, the macro variable SQLRC returns a value of 0. See Using Macro ...