SQL Builder preferences (Talend > Specific Settings)
About this task
You can set your preferences for the SQL Builder. To do so:
Procedure
From the menu bar, click Window > Preferences to open the Preferences dialog box.
Expand the Talend and Specific
Settings nodes in succession and then click Sql Builder to display the relevant view.
Customize the SQL Builder preferences according to your needs:
Select the add quotes, when you generated sql
statement check box to precede and follow column and
table names with inverted commas in your SQL queries.
In the AS400 SQL generation area,
select the Standard SQL Statement or
System SQL Statement check boxes to
use standard or system SQL statements respectively when you use an
AS/400 database.
Clear the Enable check queries in the database
components (disable to avoid warnings for specific
queries) check box to deactivate the verification of
queries in all database components.
Did this page help you?
If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!