Skip to content

Instantly share code, notes, and snippets.

@phpdave

phpdave/Alias for partition 2017 .sql

Created March 28, 2017 19:15
Show Gist options
  • Save phpdave/bc5c809875b03b72d6eee792c96e3425 to your computer and use it in GitHub Desktop.
Save phpdave/bc5c809875b03b72d6eee792c96e3425 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Alias for partition 2017 .sql
CREATE OR REPLACE ALIAS QTEMP.SALES_2017
FOR SALES(2017);
--https://www.ibm.com/support/knowledgecenter/ssw_ibm_i_73/db2/rbafzhcalias.htm
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment