DB2: Alias Cheat Sheet

Creating database object aliases

db2 create alias <alias_name> for <table_name>    

Retrieving values using alias name of the table

db2 select * from <alias_name>    

Leave a Reply

Your email address will not be published. Required fields are marked *