how to find the base table of an ALIAS ?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

bikkaran@in.ibm.com - 15 Feb 2006 11:56 GMT

how to find the base table of an ALIAS ?

thanks

Reply to this Message

Serge Rielau - 15 Feb 2006 12:29 GMT

> how to find the base table of an ALIAS ?
>
> thanks

VALUES (TABLE_SCHEMA('MYSCHEMA', 'MYALIAS'),
TABLE_NAME('MYSCHEMA', 'MYALIAS'))

You can also use recursive SQL over SYSCAT.TABLES of course.
Cheers
Serge

Signature

Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

Reply to this Message

bikkaran@in.ibm.com - 15 Feb 2006 13:35 GMT

Hi ,

Thanks a lot ...I used syscat.tables where in base_tabschema,
base_tabname gave the desired result.

Regards
bikash

Reply to this Message

Serge Rielau - 15 Feb 2006 14:06 GMT

> Hi ,
>
> Thanks a lot ...I used syscat.tables where in base_tabschema,
> base_tabname gave the desired result.

That works as long as you don't have alias on alias.
That's where recursion comes in.

Cheers
Serge

Signature

Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

Reply to this Message