cancel
Showing results for 
Search instead for 
Did you mean: 

Accessing Informix tables that have their names in lower case from BW

Former Member
0 Kudos

Can anyone please help with this?

Has anyone done it using views?

Thanks

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member181887
Active Contributor
0 Kudos

Hi Frank,

I assume you are talking about using DB Connect functionality. If this is the case, the usual workaround is to create a view on the table and have all the fields and the view name in upper case. BI would then read the meta data from the view and be able to issue select statements.

This restrictions is not in place if you use UDI functionality as the drivers can use mixed case.

I hope this helps,

Mike.