If/Then/Else
IfThenElse
Demonstrates if/tten/else for destination
auto
employee
select * from employee
employee
yes
{JOB} = 'MANAGER'
{JOB}:= 'TEST';
insert into employee (EMPNO,FIRSTNME,MIDINIT,LASTNAME,WORKDEPT,PHONENO,HIREDATE,JOB,EDLEVEL,SEX,BIRTHDATE,SALARY,BONUS,COMM) values ({EMPNO},{FIRSTNME},{MIDINIT},{LASTNAME},{WORKDEPT},{PHONENO},{HIREDATE},{JOB},{EDLEVEL},{SEX},{BIRTHDATE},{SALARY},{BONUS},{COMM});
not_managers
not_managers
employee
yes
{JOB} <> 'MANAGER'