ERROR: DM-DBM-0380 The SQL statement for data selection is not valid.
When Cognos Data Manager is failed because of DM-DBM-0380 then sql statement used in your LOOKUP function is not returning anything. For Lookup function only use SELECT Statement. If you want to use any other SQL query insure that the last statement is an SELECT Statement.
In below examples vLemonn is our SQL Server database.
Following are the correct usage of SQL Statement in Lookup function.
Following are the wrong sql statement fot Lookup function.
If you are facing any other issue, share the error message with me. I will reply the solution ASAP. Feel free to search it in our other posts.
Please login to post your valuable comments.
Get the latest vLemonn news first