Results 1 to 6 of 6

Thread: Mqt Sql!!

  1. #1
    Join Date
    Nov 2007
    Posts
    27

    Unanswered: Mqt Sql!!

    Hello Guys,
    In our DB, we are having a MQT defined on 2 tables. Now from where can I get the SQL used for creating the MQT ?

    Thanks
    Rajesh

  2. #2
    Join Date
    Jun 2006
    Posts
    471
    have you checked db2look output
    Best Regards, Guy Przytula
    DB2 UDB LUW certified V6/7/8

  3. #3
    Join Date
    Nov 2007
    Posts
    27
    No...could you please tell me how to use it??? thanks

  4. #4
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    Code:
    $ db2look -d <dbname>
    Also check "db2look -h" for further options.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  5. #5
    Join Date
    Jun 2006
    Posts
    471
    at least db2look -d dbname -e -l -o outfile
    Best Regards, Guy Przytula
    DB2 UDB LUW certified V6/7/8

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

    select text from syscat.views where viewschema = 'MySchema' and viewname = 'MyMQT'

    Andy

Posting Permissions

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