Results 1 to 3 of 3

Thread: system table

  1. #1
    Join Date
    Jul 2003
    Posts
    6

    Unanswered: system table

    i want to know db2 system tables which stores table names and column names. I want to know the query which give column names and their datatype, length of cloumn as query results when i execute it by giving table name in where clause

    can any one help?

    Thanks,
    Nagammai.

  2. #2
    Join Date
    Feb 2002
    Location
    Germany
    Posts
    141

    Re: system table

    Nagammai,

    you will find all DB2 Catalog tables in the SQL Reference. If you're running DB2 LUW, select from SYSCAT.TABLES and SYSCAT.COLUMNS. On OS390, select from SYSIBM.SYSTABLES and SYSIBM.SYSCOLUMNS.

    HTH,

    Rodney
    Rodney Krick

  3. #3
    Join Date
    Jul 2003
    Posts
    6

    Re: system table

    Thanks Rodney!

Posting Permissions

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