Results 1 to 3 of 3

Thread: readonly view

  1. #1
    Join Date
    Apr 2013
    Posts
    19

    Unanswered: readonly view

    hi buddys,

    can u pppls help me that how to create a readonly views.

    i used these command

    db2 "create view vname as select * from tablename readonly"

    but it does not created readonly view

  2. #2
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,369
    "A view can be read-only if it is a view that does not comply with at least one of the rules for deletable views."

    IBM DB2 9.7 for Linux, UNIX and Windows Information Center

  3. #3
    Join Date
    Jan 2004
    Location
    Europe, Finland, Helsinki
    Posts
    64
    Hmmhpf

    How about this:

    db2 "create view vname as select a.col1, a.col2, a.col3, ... a.col_n
    from tablename readonly a,
    sysibm.sysdummy1 b "

    Now your view should be a read-only...

    Cheers, Bill

Posting Permissions

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