@1:
Select Table_Name, Table_Schema, Base_Table_Catalog, Base_Table_Name,
Base_Table_Member
from SysTAbles
Where Table_Schema = 'YOURSCHEMA'
and Table_Name = 'YOURALIAS'
and Table_Type = 'A';
Or do an reverse engineering in ACS (or Client Access)
ACS --> Schemas --> Select your Database --> Select your Schema --> Aliases
--> Right click on the Alias and Generate SQL
Mit freundlichen Grüßen / Best regards
Birgitta Hauser
"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"
?Train people well enough so they can leave, treat them well enough so they
don't want to.? (Richard Branson)
-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxx> On Behalf Of Jack Woehr
Sent: Freitag, 2. November 2018 22:58
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Subject: Db2 CREATE ALIAS and DESCRIBE TABLE
Two q's from non-DBA:
1. Someone did CREATE ALIAS. How do I view the definition of the alias?
2. Can someone give me an example of DESCRIBE TABLE
- referring to a PF
- referring to an LF
- referring to an ALIAS
--
Absolute Performance, Inc.
12303 Airport Way, Suite 100
Broomfield, CO 80021
NON-DISCLOSURE NOTICE: This communication including any and all attachments
is for the intended recipient(s) only and may contain confidential and
privileged information. If you are not the intended recipient of this
communication, any disclosure, copying further distribution or use of this
communication is prohibited. If you received this communication in error,
please contact the sender and delete/destroy all copies of this
communication immediately.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe,
or change list options,
visit:
https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at
https://archive.midrange.com/midrange-l.
Please contact support@xxxxxxxxxxxx for any subscription related questions.
Help support midrange.com by shopping at amazon.com with our affiliate link:
https://amazon.midrange.com
midrange.com
