SEO

#1 (**permalink**) 02-27-2008, 06:05 AM

how to find the base table of an ALIAS ?

thanks

#2 (**permalink**) 02-27-2008, 06:05 AM

bikkaran@in.ibm.com wrote:
> 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
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

#3 (**permalink**) 02-27-2008, 06:05 AM

Hi ,

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

Regards
bikash

#4 (**permalink**) 02-27-2008, 06:05 AM

bikkaran@in.ibm.com wrote:
> 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

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode