.logon bteq/dbc,dbc;
. set width 255
. set maxerror 25
. set errorout stdout
Create set table empma_data,No fallback,
No Before Journal,
No After Journal,
Checksum =default
(
employee_number integer,
manager_employee_number integer,
department_number smallint,
job_code integer,
last_name char(20) Not casespecific,
first_name varchar(20) Not casespecific,
hire_date date format 'YY/MM/DD',
birthdate date format 'YY/MM/DD',
salary_amount decimal(10,2),
gender char(1) Uppercase Not casespecific);
.quit