×

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: Oct 24, 2016 9:36 PM
Views: 8
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;