In all output properties, you also have to define the schema of the output. To
retrieve the schema defined in the input schema, click the Sync
columns tab in the Basic settings view.
Information noteWarning:
When creating a database table, you are recommended to specify the
Length field for all columns of type String, Integer
or Long and specify the Precision field for all columns
of type Double, Float or BigDecimal in the schema of the component used.
Otherwise, unexpected errors may occur.
If you have installed the R2021-06 Studio monthly update or
a later one provided by Talend, the following two buttons are available at the bottom of the Schema editor
dialog box of database components for editing Db Column
names:
- : converts the Db Column name of
each selected column to upper case or lower case.
- : adds or removes quote characters in the Db
Column name of each selected column by selecting Add
quote or Remove quote and entering the
quote character in the field in a pop-up dialog box.
Information noteNote:
- The Guess Query function for database input components does not work
when quote characters are added in Db Column
names.
- Adding quote characters in Db Column names
with space characters works only if you have installed the R2021-07
Studio monthly update or a later one provided by Talend.