Results 1 to 7 of 7
  1. #1
    Join Date
    Oct 2003
    Posts
    18

    Unanswered: System catalog in db2

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

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    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

  3. #3
    Join Date
    Oct 2003
    Posts
    18

    db2

    Thanks for ur reply,Andy.

  4. #4
    Join Date
    Oct 2003
    Posts
    18

    Re: db2

    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

  5. #5
    Join Date
    Mar 2003
    Posts
    343
    Look in syscat.checks

  6. #6
    Join Date
    Oct 2003
    Posts
    18

    what sql source stmt does sys catalog contains?

    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

  7. #7
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5

    Re: what sql source stmt does sys catalog contains?

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

    Andy

    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •