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: Jan 29, 2018 7:27 PM
Views: 12
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;