Print Page - Case Sensitive Join (Local Processing)

Title: Case Sensitive Join (Local Processing)
Post by: Balthazar on 13 Aug 2015 12:04:35 AM

Hi,

I am joining a DB2 stored procedure and XML external data source. The joins are getting processed as case in-sensitive.

Is there a way to change the join to be case sensitive?

I am using Cognos Report Studio 10.1

Thanks in Advance.

Title: Re: Case Sensitive Join (Local Processing)
Post by: Balthazar on 13 Aug 2015 06:30:22 PM

I just wanted to update that I didn't find a method to make the Join Case Sensitive. Instead, I filtered the joined data and got it working.

Title: Re: Case Sensitive Join (Local Processing)
Post by: BigChris on 14 Aug 2015 04:31:47 AM

Obviously this isn't a solution to your problem, but I was under the impression the case sensitivity was set at the database level. If that's the case (no pun intended), the sensitivity will be global.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: Balthazar on 13 Aug 2015 12:04:35 AM