What information can you find in SYSIBM.SYSLINKS table?
Answer / nahid gorji
SYSIBM.SYSLINKS contains information about the table-to-
table links that make up the physical structure and storage
of the DB2 Catalog. Links are internal structures similar
to RI relationships. Not all catalog tables use links.
Tablespace DSNDB06.SYSDBASE
Indexes None
Links DSNDR#DL REFERENCES SYSIBM.SYSRELS
| Is This Answer Correct ? | 3 Yes | 1 No |
in my table i will update only 100 record among 1000 records i need to display recently updated record'.....can u tell me where those records are stored how can i display those records...?if there is any sql query pls let me know....?
Explain about rct.
What is meant by repeatable read?
What are the disadvantages of PAGE level lock?
What is a plan and package in db2?
What do you need to do before you do EXPLAIN?
What is a SELECT statement?
One program calling 5 subprograms, its a cobol db2 program, after precompilation how many plans and packages will created?
What is the function of the Data Manager?
if suppose i am having an ACCOUNT table with 3 coloumns ACC. NO,ACC. NAME,ACC. AMOUNT . If a unique index is also defined on ACC.NO and ACC.NAME then write a query to retrieve account holders records who have more than 1 ACC.
What is the physical storage length of timestamp data type?
What is correlation names?