create table  TBNAME as
(Select emp_num, manager_employee_number, job_code, last_name, first_name, 
salary, salary+5 (NAMED salary1), 
salary1*2 (NAMED salary2)
From DBNAME.TBNAME
where salary2 >2000 ) with data 
PRIMARY INDEX (emp_num) ;