SQL Builder preferences (Talend >
Specific Settings)
About this task
You can set your preferences for the SQL Builder.
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!