Column names with lowercase characters

[rob_reijmers]

Hi,

We are using Talend 6.2.1. and Exasol 5.0

I'm transferring data from a table to another table (see Uppercase_1). I want to use lowecase column names, e.g. Material_no and Language (see Uppercase_2). Also in the output schema it's in lowercase. (see Uppercase_3). I run the job and create the table (see Uppercase_4). It is running fine, but if I look into the create scipts (see Uppercase_5) I see MATERIAL_NO and Language. Change the the create to Material_no and Language (see Uppercase_6) and running with truncate table, i get an error "object MATERIAL_NO not found" (see Uppercase_7).
It looks like reserved words are transferred to lowercase, but non-reserved wordt not. You see this back in the code, Talend is generating a \" around Language and nothing around Material_No (see Uppercase_8).
Has someone a suggestion how to deal with this?

Regards,
Rob Reijmers
Uppercase1
 
Uppercase 2


Uppercase3
 

Uppercase4


Uppercase5


Uppercase6


Uppercase7


Upercase8

[Anonymous]

Hi,
We can't see the screenshot on our side. Could you attach it on the forum, please? That would be great.
Best regards
Sabrina

[rob_reijmers]

Hi,

I tought they were uploaded, but now it's in the zio-file.

Regards,
Rob

Screenshots.zip.zip

[Anonymous]

Hi,
The .zip file is not available on forum. Can you click "UPLOAD" button to attach your screenshots?
Note: Screenshots works only if you drag&drop the image directly in the editor window.
Best regards
Sabrina

[rob_reijmers]

Hi,

I managed it to do it on the original post. I hope you can give a suggestion.

Regards,
Rob

[rob_reijmers]

Hi,

Has somebody a suggestion??

Regards,
Rob