You can translate the question and the replies:

Fetching columns from denodo with space in column names through informatica bdm

While selecting columns with space in column names from denodo , informatica bdm is throwing error as such a column doesnot exist.
user
28-01-2020 03:44:08 -0500

1 Answer

Hi, Spaces in elements' names are only allowed in Virtual DataPort when the [identifiers charset](https://community.denodo.com/docs/html/browse/latest/vdp/administration/server_administration_-_configuring_the_server/identifiers_charset/identifiers_charset#identifiers-charset) is set to ["Unicode" mode](https://community.denodo.com/docs/html/browse/latest/vdp/administration/server_administration_-_configuring_the_server/identifiers_charset/identifiers_charset#unicode-mode). When I execute a query which contains spaces in the column name from a third-party database client, I make sure that I have surrounded the column name in quotes. For example: ``` SELECT "column name" FROM <view_name>; ``` Hope this helps!
Denodo Team
29-01-2020 21:08:34 -0500
You must sign in to add an answer. If you do not have an account, you can register here