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 |
What's The Error Code For Unique Index Voilation?
What does db2 stand for?
What is UNION,UNION ALL?
Outputs of explain are with matchcols = 0. What does this signify?
what is sql abend code -801,-802?
Is Cursor exicutable ?
What is a composite index and how does it differ from a multiple index?
Why do we use cursor?
Suppose I have a program which uses a dynamic SQL and it has been performing well till now. Off late, I find that the performance has deteriorated. What happened?
What is the picture clause of the null indicator variable?
Is the primary key a clustered index?
we can code COPY DCLGEN or INCLUDE DCLGEN, At which stage of the precompilation , dclgen get expanded if we write 1) copy 2) include one question about dclgen.. Is it mandatory to use declare table in dclgen.. I think no...but it will be used by the precompiler to validate the table name,column name etc.., can one clear my doubt ..is it necessary to include declare table or not?