Interested to Buy Any Domain ? << Click Here >> for more details...
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..
- 5 Answers
- 11856 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / apoorv sharma
Learn SQL Trace for that... Tcode is ST05.
After this u will come to know which table contain those fields
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How would you find out the total number of rows in a db2 table?
What is check constraint. Explain with example.
Where can you declare a cursor in a cobol-db2 program?
What is the maximum No of rows per page?
What is a trigger in the db2 database?
what is utility for parm lib
Why db2 is called db2?
Why do we use cursor?
What is db2 bind?
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
What is copy pending status in db2?
What is bind and rebind in db2?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
What is the information associated with sysibm.syslinks table?
How do we specify index to include or not during bind process.
