While checking SQL syntax itself is somewhat straightforward, [Joe]’s sql-lint tool will also check the semantics of it by looking up the actual database and performing sanity checks on it.

This transaction is affected by any SQL COMMITs or ROLLBACKs that are performed within the connection while executing the Pass-Through statements. The values for CONNECTION= are as follows: SHARED ...

In this sample statement, the condition (table1.keyfield=table2.keyfield) tells SQL to find records in both tables that contain matching values in the column named by keyfield.

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