 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussion Groups Database Servers DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybaseDesktop Databases FileMakerFoxProMS AccessParadoxGeneral General DB TopicsDatabase TheoryRelated Topics Java Development.NET DevelopmentVB DevelopmentMore Topics ... |
Database Forum / DB2 Topics / January 2006Retrieving 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 There is a tableid associated with each tables in syscat.tables system view. Is this the same thing? TIA > Greetings, > Do we have the concept of ID's assigned to objects like [quoted text clipped - 3 lines] > > 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  SignatureSerge Rielau DB2 Solutions Development DB2 UDB for Linux, Unix, Windows IBM Toronto Lab Thanks Serge. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.