topic Re: Column names with lowercase characters in Talend Studio

Column names with lowercase characters

rob_reijmers — Tue, 27 Dec 2016 13:27:53 GMT

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

Re: Column names with lowercase characters

Anonymous — Wed, 28 Dec 2016 03:19:56 GMT

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

Re: Column names with lowercase characters

rob_reijmers — Wed, 28 Dec 2016 06:49:07 GMT

Hi,

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

Regards,
Rob

Screenshots.zip.zip

Re: Column names with lowercase characters

Anonymous — Wed, 28 Dec 2016 07:43:56 GMT

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

Re: Column names with lowercase characters

rob_reijmers — Wed, 28 Dec 2016 08:44:31 GMT

Hi,

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

Regards,
Rob

Re: Column names with lowercase characters

rob_reijmers — Wed, 04 Jan 2017 12:54:03 GMT

Hi,

Has somebody a suggestion??

Regards,
Rob