Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2005
    Posts
    127

    Question Unanswered: How to retrieve information about the database objects

    hi,

    In SQL Server we ve some system tables which have some information about the database,

    1. sysobjects : which stores the information regarding the database objects like table, procedure , etc...

    it has information like the name of the object, type (procedure or table or trigger ...), specific id for the object.

    2. systypes : it has information about the data types like, the name of the datatype, the space it occupies, physical storage type, etc..


    I want to retrieve similar information from DB2, Kindly guide me to find the equivalent information in DB2,.

    Regards,
    Sn

  2. #2
    Join Date
    Nov 2004
    Posts
    1,427
    Provided Answers: 4
    Look for tables with schema name SYSIBM, SYSCAT, ...
    With kind regards . . . . . SQL Server 2000/2005/2012
    Wim

    Grabel's Law: 2 is not equal to 3 -- not even for very large values of 2.
    Pat Phelan's Law: 2 very definitely CAN equal 3 -- in at least two programming languages

  3. #3
    Join Date
    Oct 2005
    Posts
    109
    1): you are probably referring to the system catalog:

    on LUW: all the SYSCAT.* views
    http://publib.boulder.ibm.com/infoce...n/r0008443.htm

    on z/OS: all the SYSIBM.SYS% Tables.
    http://publib.boulder.ibm.com/infoce...jnrmstr523.htm

    They are all very well documented.

    2) data types:
    may be that is useful for you ?
    http://publib.boulder.ibm.com/infoce...n/r0008483.htm
    http://publib.boulder.ibm.com/infoce...n/c0004924.htm
    http://publib.boulder.ibm.com/infoce...n/c0004926.htm
    Juliane

  4. #4
    Join Date
    Apr 2005
    Posts
    127
    THanks for the links and the suggestions. I ll try to use them.

    Regards
    Sn

Posting Permissions

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