Suggest a feature
×

Welcome to TagMyCode

Please login or create account to add a snippet.
0
0
 
0
Language: SQL
Posted by: Jo Me
Added: Mar 19, 2015 5:19 PM
Modified: May 31, 2018 3:25 PM
Views: 21
Create an Alias for a Library/File(Member) under the DB2 for IBM i database.
  1. CREATE ALIAS QTEMP.aliasname FOR Library/TABLE (member);
  2. SELECT * FROM QTEMP.aliasname;
  3. DROP ALIAS QTEMP.aliasname;