Hi,

I just have name of the object which is table or view.
How to know which one it is ?

thanks
Vilius

SYSIBM.SYSTABLES catalog table has a type column where you can check whether the object is of type table or view.

SELECT name, type from sysibm.systables where name='object name'

Gives whether the "name" object is of type table or view or alias.

Type of objects are
A - Alias
T - Table
V - View

For more info you can refer to
http://publib.boulder.ibm.com/infoce...ablestable.htm

Thanks,
Madhavi.

SYSIBM.SYSTABLES catalog table has a type column where you can check whether the object is of type table or view.

SELECT name, type from sysibm.systables where name='object name'

Gives whether the "name" object is of type table or view or alias.

Type of objects are
A - Alias
T - Table
V - View

For more info you can refer to
http://publib.boulder.ibm.com/infoce...ablestable.htm

Thanks,
Madhavi.

if type of object is N - then it means it is a nickname which is used in case of federated databases.

Nicknames exist in DB2 LUW and there you query SYSCAT.TABLES. The tables in the SYSIBM schema are not documented (except SYSIBM.SYSDUMMY1) and relying on them in DB2 LUW is like begging for problems.