we are trying to compile a SP using
db2 -td@ -f new_sp.sql
but its giving error
DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned:
SQL0551N "GEN01" does not have the privilege to perform operation "SELECT" on
object "LEN.CM_TRAN". LINE NUMBER=259. SQLSTATE=42501
but the same user can select any rows from LEN.CM_TRAN table. So why it gives such error.