Hello All,

When the Tables are imported into the Data Module Column Names with Characters such as underscore (_), dash (-), or slash (\) are replaced with the space character.

Is there a way to stop this behavior and keep the Database Table Column Names as is in the Data Module ?

Thank You

------------------------------
Harun Y
------------------------------

#CognosAnalyticswithWatson

Anyone has any idea ?

------------------------------
Harun Y
------------------------------

From my observations It carries DB names when:-

• If You select both checkbox under Load Options for all Tables in Data Server
• If you use Native SQL ( select * from Table)

------------------------------
Buddhi Gupta
------------------------------

Original Message:
Sent: Mon August 17, 2020 03:07 AM
From: Harun Y
Subject: Data Module - Restrict Table Column Name Changes

Anyone has any idea ?

------------------------------
Harun Y
------------------------------

Thank You Buddhi @Buddhi Gupta​ it helped. I checked both Load Options in Data Server and used Pass through SQL (Select * from Table) which now displays the names as is.

I am currently using Data Module and with the Pass through SQL I wouldn't be able to use the Data Module and give users access to the same Data Module.

Cognos should have left this as Customer Choice either to replace the names or keep as is.

------------------------------
Harun Y
------------------------------

Original Message:
Sent: Mon August 17, 2020 08:13 AM
From: Buddhi Gupta
Subject: Data Module - Restrict Table Column Name Changes

From my observations It carries DB names when:-

• If You select both checkbox under Load Options for all Tables in Data Server
• If you use Native SQL ( select * from Table)

------------------------------
Buddhi Gupta
------------------------------


Original Message:
Sent: Mon August 17, 2020 03:07 AM
From: Harun Y
Subject: Data Module - Restrict Table Column Name Changes

Anyone has any idea ?

------------------------------
Harun Y

Submitted Enhancement request. Anyone looking for the similar functionality can VOTE for the below enhancement request.

https://ibm-data-and-ai.ideas.aha.io/ideas/CA-I-2893

Thank You

------------------------------
Harun Y
------------------------------

Original Message:
Sent: Tue August 18, 2020 11:34 PM
From: Harun Y
Subject: Data Module - Restrict Table Column Name Changes

Thank You Buddhi @Buddhi Gupta​ it helped. I checked both Load Options in Data Server and used Pass through SQL (Select * from Table) which now displays the names as is.

I am currently using Data Module and with the Pass through SQL I wouldn't be able to use the Data Module and give users access to the same Data Module.

Cognos should have left this as Customer Choice either to replace the names or keep as is.

------------------------------
Harun Y
------------------------------


Original Message:
Sent: Mon August 17, 2020 08:13 AM
From: Buddhi Gupta
Subject: Data Module - Restrict Table Column Name Changes

From my observations It carries DB names when:-

• If You select both checkbox under Load Options for all Tables in Data Server
• If you use Native SQL ( select * from Table)

------------------------------
Buddhi Gupta


Original Message:
Sent: Mon August 17, 2020 03:07 AM
From: Harun Y
Subject: Data Module - Restrict Table Column Name Changes

Anyone has any idea ?

------------------------------
Harun Y