Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Unanswered: Re: Data Dictionary

    Check if the SYSTABLES and SYSCOLUMNS views(tables?) will help you

    Cheers

    Sathyaram



    Hi there, all you cheerful,
    I am very new to DB2. But am asked to print reports connecting to a IBM AS400 database. How do I get a list of tables and their related fields. (For eg, SELECT * FROM DICT & DESC <TABLENAME> as used in Oracle)

    Thanks

    Pat

  2. #2
    Join Date
    Jun 2002
    Posts
    1
    Hello,
    in DB/2 must following statement:

    db2 describe select * from <schema.tablename>

Posting Permissions

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