|
View previous topic :: View next topic
|
| Author |
Message |
Abijoy
New User
Joined: 24 Mar 2010
Posts: 12
Location: Bangalore
|
|
|
|
Hi,
What is the difference between the creator and owner of a table? |
|
| Back to top |
|
 |
sushanth bobby
Senior Member
Joined: 29 Jul 2008
Posts: 1020
Location: India
|
|
|
|
Abijoy,
As per the DB2 V9 SQL REFERENCE manual
Creator
| Quote: |
| The schema of the table, view, or alias. |
Owner
| Quote: |
Authorization ID of the owner of the table, view, or alias,
blank for tables, views or aliases that were created in a
DB2 release prior to Version 9. |
Thanks,
Sushanth |
|
| Back to top |
|
|
Abijoy
New User
Joined: 24 Mar 2010
Posts: 12
Location: Bangalore
|
|
|
|
| Thanks sushanth. |
|
| Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne
|
|
|
|
Though this is an old thread,
and sushanth gave a good and accurate answer,
this link in the IBM Systems Magazine is a nice little discussion on the topic.
I would suggest that everyone subscribe to the Magazine.
Topics are varied - db2, ispf, tso
plus IBM's continual propaganda about its hardware,
which is good IMUO. |
|
| Back to top |
|
|
|
|
