Prem Prakash
New User
Joined: 07 Jan 2006 Posts: 6 Location: India
|
|
|
|
Hi all,
i have created some tables in this format, "AIS.Table_Name" using my mainframe ID. Now if i am querying in SYSIBM.SYSTABLES then its showing AIS as the creator of table, not my id!!!! what is the logic behind this:?: |
|
martin9
Active User
Joined: 01 Mar 2006 Posts: 290 Location: Basel, Switzerland
|
|
|
|
hy Prem Prakash,
the field CREATOR is AIS, as you defined...
your userid is in the field TBCREATOR, which
takes its value from the current SQLID, which
is normally identical to your userid.
you can change this value with the SET SQLID=,
but you need to specify any other id, which you
have authoriries too. (i.e. SYSADM, DBADM...)
martin9 |
|