SQL Statement Generation Settings

www.altova.com Print this Topic Previous Page Up One Level Next page

Home >  Data Sources and Targets > Databases and MapForce > Browsing and Querying Databases > Database Query Settings >

SQL Statement Generation Settings

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 ic-sql-options, and then click SQL Editor.

dbquery_settings_generation

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.


© 2019 Altova GmbH