System catalog in db2

manga · #1 (**permalink**) 10-08-03, 16:15

It will be great if anyone can let me know what will system catalog contain? packages ,tables,views,indexes,triggers or what?

ARWinner · #2 (**permalink**) 10-08-03, 16:43

Yes, it contains all that and more.

Look in the SQL Reference manual: Appendix D (V7.x , 8.x)
to see all the views defined for the catalog.

Andy

manga · #3 (**permalink**) 10-08-03, 20:52

Thanks for ur reply,Andy.

manga · #4 (**permalink**) 10-17-03, 16:41

I like to know for what, sql source statements will be there in system catalog? In one book I read that constraints and triggers have sql source stmts..but when i tried syscat.triggers and syscat.views, I got sql source stmt but not for constraints..
can anyone clarify this?

-manga

cchattoraj · #5 (**permalink**) 10-20-03, 11:47

Look in syscat.checks

manga · #6 (**permalink**) 10-20-03, 14:33

Sorry...I didn't understand..Do u mean to say that we can find sql source stmts in syscat.checks? If so, I entered select * from syscat.checks and did get any sql code...can u please clarify on this?

-manga

ARWinner · #7 (**permalink**) 10-20-03, 14:58

Manga,
I think what you are looking for is in syscat.columns.text

Andy

Quote:

Originally posted by manga
Sorry...I didn't understand..Do u mean to say that we can find sql source stmts in syscat.checks? If so, I entered select * from syscat.checks and did get any sql code...can u please clarify on this?

-manga

Internet Services

Web Development

Digital Marketing

Consumer Tech