CSV file as a data source in cognos Framework Manager using Microsoft text drive

[sunny bachan prasad]

Hi,

I am using CSV file as a data source in cognos 10.2.2 framework manager and it is connected as a  microsoft text driver(*txt;*CSV) in ODBC . I have to define one filter for the query subject created by this data source which uses substring but while validating the model i am getting error as mention below can any one share experience on this?


"UDA-SQL-0043 The underlying database detected an error during processing the SQL request.[Microsoft][ODBC Text Driver] Undefined function 'substring' in expression"

Thanks in Advance
Sunny

[bdbits]

Unfortunately, it appears substring() is not supported for the text driver.

Could the file be ETLed to your database? This will give you a lot more flexibility.