You can specify the SQL statement generation syntax for various database kinds as follows:
1.Click the DB Query tab.
2.At the top of the pane, click Options , and then click SQL Editor.
To define the syntax preferences for a specific database, select it from the list, and then enable or disable the three check boxes to the right.
To define a unique syntax for all databases, select Apply to all databases, and then enable or disable the three check boxes to the right. Note that using common settings for all databases may cause inability to edit data in Oracle and IBM DB2 and iSeries databases via a JDBC connection.