469,951 Members | 2,719 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,951 developers. It's quick & easy.

Retrieving Object ID's

Greetings,
Do we have the concept of ID's assigned to objects like
tables, indexes, view etc.
I mean in sybase we have a function to select the object ID's. Do we
have this concept in DB2. If yes, how can we do it?

Any help would be appreciated.

TIA

Jan 12 '06 #1
3 5058
There is a tableid associated with each tables in syscat.tables system
view.
Is this the same thing?

TIA

Jan 12 '06 #2
pa***************@yahoo.co.in wrote:
Greetings,
Do we have the concept of ID's assigned to objects like
tables, indexes, view etc.
I mean in sybase we have a function to select the object ID's. Do we
have this concept in DB2. If yes, how can we do it?

Any help would be appreciated.

DB2 only has routineid for functions and procedure.
And sequence ID for sequences.
table objects have no abstract ID.
An object is uniquely identified by its type, and fully qualified
(specific) name.

Cheers
Serge

--
Serge Rielau
DB2 Solutions Development
DB2 UDB for Linux, Unix, Windows
IBM Toronto Lab
Jan 12 '06 #3
Thanks Serge.

Jan 13 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Dirk Vervecken | last post: by
13 posts views Thread by RHPT | last post: by
reply views Thread by fernandezr | last post: by
3 posts views Thread by Ramon | last post: by
11 posts views Thread by Nemisis | last post: by
5 posts views Thread by Randy Smith | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.