Answer Posted / prem
Use the Describe command
eg: Describe table <tablename>
| Is This Answer Correct ? | 38 Yes | 47 No |
Post New Answer View All Answers
What is the difference between plan and package in db2?
what is a corelated subquerry?
What is db2 look?
What is commit in db2?
What is alias in db2?
What's The Error Code For Unique Index Voilation?
What is dpf in db2?
When the like statement is used?
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
Which isolation level provides highest data integrity?
Why db2 is called db2?
How does a cursor work?
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 .....
How would you find out the total number of rows in a db2 table?
What is difference between alias and synonym in db2?