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 |
Which are the db2 tools to protect integrity of the database?
I have some 3 particular fields ..i want to know which all tables have those 3 fields. Is there any way to identify.. can we know by quering system tables..
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
What is meant by a unit of recovery?
what is a collection?
How do I delete a column in db2?
What is EXPLAIN?
where can we use index and subscript ? with example ?
What is the significance of the CURSOR WITH HOLD clause in a cursor declaration?
How to check table size in db2 sap?
Can we able to find all the Table names under a Particular Plan?
Q1. How will you use two different DB2 qualifiers in a single COBOL program? Suppose we have 2 tables EMP1 and EMP2 with same structure defined in two different DB2 qualifiers QUAL1.EMP1 and QUAL2.EMP2 now during first 15 days we want to use QUAL1.EMP1 and rest of the days QUAL2.EMP2 how will we do this. We can create a single program and a single load for this program.