error while using DB2 stage

ramesh_inform · Post by **ramesh_inform** » Thu Apr 10, 2008 1:53 am

the error is :

"RNANDIP" does not have the privilege to perform operation "SELECT"
on object "MR3402.INB_BRKG_CUST". SQLSTATE=42501

my job design looks like this

seq file--->copy--->DB2 stage

any idea??

ray.wurlod · Post by **ray.wurlod** » Thu Apr 10, 2008 3:34 pm

"RNANDIP" does not have the privilege to perform operation "SELECT"
on object "MR3402.INB_BRKG_CUST".

DataStage needs SELECT privilege to check metadata and to perform View Data. And if you don't have SELECT privilege, chances are that you don't have INSERT and UPDATE privilege also. Check with your DBA.