Please enable JavaScript to view this site.

Altova MapForce 2020 Professional Edition

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