What is sqlcode -922 ?
Answers were Sorted based on User's Feedback
Answer / kanagaraj
Yes correct. In this case plan is exist but your racf
doesn't have privilage to access that plan.
It will be reslove by below command
grant execute planname to PUBLIC
you need to execute this command under creator of the plan
because plan owner have the full access.
| Is This Answer Correct ? | 15 Yes | 2 No |
What happens to a tablespace when its recovery infromation has been removed and a full recovery is no longer possible?
What are the various isolation levels possible?
What are types of indexes?
What does db2 stand for?
how many partitions are possible in partitioned tablespace? dont say 1-64. a)240 b)256 c)512 d)none
What is an inner join, and an outer join ?
When Can you be sure that a query will return only one row?
What are the two types of logging in the db2 database? Explain them.
can I alter a table (e.g. adding a column) when other user is selecting some columns or updating some columns from the same table?
How would you print the output of an SQL statement from SPUFI?
i want to know how the commit option works,how it save the changes? it will update the database or what ? where we can see these saved changes?
What is the reason behind not using select * in embedded sql programs?