Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2004
    Posts
    17

    Unanswered: Is there a user can refer to many schemas

    In oracle, I know that a user only refer to a shcema. In DB2,is there a user can refer to many schemas

  2. #2
    Join Date
    Feb 2002
    Posts
    96
    Yes. You can refer it by schema.tablename
    eg:
    select * from schema1.table1
    select * from schema2.table2
    select * from schema3.table3


    If you create tables/views by USER1, then you are not necessary to refer by schema.tablename (select * from table1 --> will do). But other users have to use schema.tablename.

    Regards
    Prakash

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

    And in DB2 for z/OS environment, you can use SET CURRENT PACKAGESET statement to obtain dynamic schema selection.

    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
  •