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 |
Define sqlca.
What is the significance of DB2 free space and what parameters control it?
Say CUST Table contains records like: CUSTNO CUSTNAME CUSTLOC 100 ABC SSS 200 XYZ 300 PQR 400 MNO WWW 500 CVV ------------- ------------- Now write a query to retrieve all records with CUSTLOC no data.
How connect db2 database to datastage?
How do you simulate the explain of an embedded sql statement in spufi/qmf?
What's the maximum number of volumes that can be added to a STOGROUP?
Can we update view in db2?
What is the purpose of the SDSNLOAD dataset in the STEPLIB while running DB2 programs?
What is the reason behind not using select * in embedded sql programs?
What is the use of COMMAREA ?Minimum how much data we can pass from it?
In cobol+DB2program if the code of cobol program has changed than i have to do precompilation once again?
What are the levels of isolation available with DB2V4