Lookup DM-DBM-0380 The SQL statement for data selection is not valid

Lookup DM-DBM-0380 The SQL statement for data selection is not valid

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.

  1. LOOKUP('vLemonn','USE vLemonn;SELECT * FROM tblEmployee WHERE EmployeeID=1;');.
  2. LOOKUP('vLemonn','USE vLemonn;DELETE FROM tblEmployee WHERE EmployeeID=1;SELECT * FROM tblEmployee WHERE EmployeeID=1;');.

Following are the wrong sql statement fot Lookup function.

  1. LOOKUP('vLemonn','USE vLemonn;');.
  2. LOOKUP('vLemonn','DELETE FROM tblEmployee WHERE EmployeeID=1');.
  3. LOOKUP('vLemonn','SELECT * FROM tblEmployee WHERE EmployeeID=1;DELETE FROM tblEmployee WHERE EmployeeID=1');.
  4. LOOKUP('vLemonn','SELECT * FROM tblEmployee WHERE EmployeeID=1;USE vLemonn;');.

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.

0 Comments
Leave A Comment

Please login to post your valuable comments.

Join the newsletter

Get the latest vLemonn news first

share