Question on OWNER in DB2
Posted: Thu Jan 24, 2013 10:08 amHi,
Good Day.
1. We have owner IBIS for our database IBIS. Mostly we refer the table as IBIS.TABLE_NAME. Hence what is mean by OWNER , is it called SCHEMA ? What is the difference between OWNER and SCHEMA ?
2. In my BIND Parameter, if i mention OWNER(IBIS) then is it necessary i should refer the table as IBIS.TABLE_NAME in the program or is it enough to mention only the table name. ?
3. What is SYSIBM means if i refer table SYSIBM.SYSTABLESPACE ?
Good Day.
1. We have owner IBIS for our database IBIS. Mostly we refer the table as IBIS.TABLE_NAME. Hence what is mean by OWNER , is it called SCHEMA ? What is the difference between OWNER and SCHEMA ?
2. In my BIND Parameter, if i mention OWNER(IBIS) then is it necessary i should refer the table as IBIS.TABLE_NAME in the program or is it enough to mention only the table name. ?
3. What is SYSIBM means if i refer table SYSIBM.SYSTABLESPACE ?