Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2005
    Posts
    6

    Question Unanswered: System tables in DB2 UDB

    Hi All,

    Can any one tell me the query to find the name of the database table.
    I know the description of a column,but I dont know the data is in which column and which table.
    How can I do this ....
    I went through all the system defined tables but I could'nt trace out.

    In oracle we can do the same I guess with the the system table called either usercolumns or user objects....I dont know perfectly...but we can do in oracle..

    How can this be done in DB2 UDB..

    Very Urgent...
    Query Expected from all DB2 Gurus...

    Thanks in Advance
    Milind

  2. #2
    Join Date
    Aug 2002
    Location
    Coventry, England
    Posts
    4

    Smile

    Simple use the command:
    db2 describe table sysibm.systables

    The "name" and "creator" columns will link to the "tbname" and "tbcreator" columns of table sysibm.syscolumns.

  3. #3
    Join Date
    Jan 2005
    Posts
    191
    "Query Expected from all DB2 Gurus... " !! EXPECTED?? What gives you the right to expect a response from anyone?

    It was after re-reading that that I deleted the one I had written.

    James Campbell

  4. #4
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    See the DB2 Catalog Tables in the appendix of SQL Reference Vol 1.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

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