Advertisement
Guest User

Untitled

a guest
Feb 13th, 2016
50
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.43 KB | None | 0 0
  1. create multisite table HR.Employees_tbl1 as
  2. (
  3. select Emp_ID varchar(50),
  4. Emp_Date 'yyyy-mm-dd',
  5. Notes 'Varchar(200)
  6. ) with data PI (Emp_ID);
  7. collect stats on HR.Employees_tbl1 column (Emp_ID);
  8.  
  9.  
  10. create multisite table HR.Employees_tbl2 as
  11. (
  12. select Emp_ID varchar(50),
  13. Ref_Date 'yyyy-mm-dd',
  14. Ref_Source 'Decimal(18,0)
  15. ) with data PI (Emp_ID, Ref_Source);
  16. collect stats on HR.Employees_tbl2 column (Emp_ID, Ref_Date, Ref_Source);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement