DB2 SQL Error: SQLCODE=-551, SQLSTATE=42501

Asked Jul 19 '16 at 16:00

Active Jul 21 '16 at 19:49

Viewed 1.3k times

I try to run a query on db2 but I get the following error :

 DB2 SQL Error: SQLCODE=-551, SQLSTATE=42501, SQLERRMC=GCD_ADMIN;SELECT;GCD_ADMIN.TAYEBEDS, DRIVER=4.7.85

this is my code :

 results = stmt.executeQuery("select "+schema +"."+ edsTable + ".OBJECTTYPE from "+ schema +"."+ edsTable);

edited Jul 21 '16 at 19:49

mustaccio

asked Jul 19 '16 at 16:00

khadi8

1

It may be a problem of missing privileges for the current user, see here : http://stackoverflow.com/questions/1588687/db2-connection-problem-with-java – Arnaud Jul 19 '16 at 16:04
how can i add privilege with DB2 CLP for this user ? – khadi8 Jul 19 '16 at 16:15
db2 grant dataaccess on database to user – Mustafa DOGRU Jul 19 '16 at 16:33
`db2 grant select on GCD_ADMIN.TAYEBEDS to user GCD_ADMIN;` – Hogan Jul 19 '16 at 17:50
make a var and log your command. Then execute the command. You might need to just trim up the variables in your sql statement. – danny117 Jul 19 '16 at 19:26

0 Answers0