Interested to Buy Any Domain ? << Click Here >> for more details...
Can we able to find all the Table names under a Particular
Plan?
- 1 Answers
- 6571 Views
- CTS, I also Faced
- E-Mail Answers
Answer / vat
Absolutely! Just look at the catalog table SYSIBM.SYSPLANDEP
It's pretty straight forward! It recrods the dependencies
of plans on tables, views, synonyms, table spaces, indexes,
aliases, functions and stored procedures.
| Is This Answer Correct ? | 12 Yes | 0 No |
How can you display the current date & current time ?
What is blu acceleration in db2?
I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?
If I have 5 Queries in a DB2 Cobol program , while precompiling how many DBRMs will get created and How many Plans and Packages will get created while Bind Process?
where can we use index and subscript ? with example ?
What is commit in db2?
For update of a row in cursors, when do we move value into host variable in cobol progrm? is it before open or before fetch ?
What is db2 command?
What is meant by AUTO COMMIT?
How to rename a table in DB2 ?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
How to retrieve rows from a db2 table in embedded sql?
COBOL 
