Results 1 to 5 of 5
  1. #1
    Join Date
    Nov 2003
    Posts
    121

    Unanswered: how to see view details

    Is there any command to show details of the view ( the actual SQL used to create view ) ?

    Thanks

  2. #2
    Join Date
    Mar 2004
    Posts
    448
    Syscat.view column text

    mujeeb

  3. #3
    Join Date
    Mar 2004
    Posts
    448
    sorry the view name is views

    regards,

  4. #4
    Join Date
    Nov 2003
    Posts
    121

    so there is no command

    Do we need to query syscat tables only to see the text for view creation?

  5. #5
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    SYSCAT.VIEWS , Column TEXT
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

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