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:?:
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...)