This section depicts the formation of assumed name and recovering information utilizing pseudonym of database objects.
Introduction
Assumed name is an elective name for database objects. It tends to be utilized to reference the database object. You can say, it is a moniker for database objects. Nom de plume are characterized for the items to make their name short, along these lines lessening the question size and expanding comprehensibility of the inquiry.
Creating database object aliases
You can create database object alias as shown below:
Syntax:
db2 create alias <alias_name> for <table_name>
Example: Creating alias name for table “professional.customer” table
db2 create alias pro_cust for professional.customer
If you pass “SELECT * FROM PRO_CUST” or “SELECT * FROM PROFESSIONAL.CUSTOMER” the database server will show the same result.
Syntax: [To retrieve values from a table directly with schema name]
db2 select * from <schema_name>.<table_name>
Example: [To retrieve values from table customer]
db2 select * from professional.customer
Output:
CUSTID FULLNAME PHONE
------- --------- ------------
100 ravi 9898989
101 krathi 87996659
102 gopal 768678687
3 record(s) selected.
Retrieving values using alias name of the table
You can retrieve values from database using alias name as shown below:
Syntax: [To retrieve values from table by calling alias name of the table]
db2 select * from <alias_name>
Example: [To retrieve values from table customer using alias name]
db2 select * from pro_cust
Output:
CUSTID FULLNAME PHONE
------- --------- ------------
100 ravi 9898989
101 krathi 87996659
102 gopal 768678687
3 record(s) selected.
