SQL Builder preferences (Talend > Specific Settings) - Cloud - 8.0

Talend Studio User Guide

Version
Cloud
8.0
Language
English
Product
Talend Big Data
Talend Big Data Platform
Talend Cloud
Talend Data Fabric
Talend Data Integration
Talend Data Management Platform
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Real-Time Big Data Platform
Module
Talend Studio
Content
Design and Development
Last publication date
2024-02-29

About this task

You can set your preferences for the SQL Builder.

Procedure

  1. From the menu bar, click Window > Preferences to open the Preferences dialog box.
  2. Expand the Talend and Specific Settings nodes in succession and then click Sql Builder to display the relevant view.
    Sql Builder view.
  3. 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.