hi,

In SQL Server we ve some system tables which have some information about the database,

1. sysobjects : which stores the information regarding the database objects like table, procedure , etc...

it has information like the name of the object, type (procedure or table or trigger ...), specific id for the object.

2. systypes : it has information about the data types like, the name of the datatype, the space it occupies, physical storage type, etc..


I want to retrieve similar information from DB2, Kindly guide me to find the equivalent information in DB2,.

Regards,
Sn

Look for tables with schema name SYSIBM, SYSCAT, ...

1): you are probably referring to the system catalog:

on LUW: all the SYSCAT.* views
http://publib.boulder.ibm.com/infoce...n/r0008443.htm

on z/OS: all the SYSIBM.SYS% Tables.
http://publib.boulder.ibm.com/infoce...jnrmstr523.htm

They are all very well documented.

2) data types:
may be that is useful for you ?
http://publib.boulder.ibm.com/infoce...n/r0008483.htm
http://publib.boulder.ibm.com/infoce...n/c0004924.htm
http://publib.boulder.ibm.com/infoce...n/c0004926.htm

THanks for the links and the suggestions. I ll try to use them.

Regards
Sn