Teradata FastLoadジョブ スクリプトの記述 - FastLoad

Teradata FastLoadジョブ スクリプトを作成して、flinsert.fastloadという名前を付けて保存します。このファイルは、6個のレコードから成るinsert.dataファイルをemployee表にロードします。

sessions 2;
errlimit 25;
logon tdpid/username,password;
CREATE TABLE employee (
       EmpNo SMALLINT FORMAT ‘9(5)’ BETWEEN 10001 AND 32001 NOT NULL,
       Name VARCHAR(12),
       DeptNo SMALLINT FORMAT ‘999’ BETWEEN 100 AND 900 ,
       PhoneNo SMALLINT FORMAT ‘9999’ BETWEEN 1000 AND 9999,
       JobTitle VARCHAR(12),
       Salary DECIMAL(8,2) FORMAT ‘ZZZ,ZZ9.99’ BETWEEN 1.00 AND 999000.00 ,
       YrsExp BYTEINT FORMAT ‘Z9’ BETWEEN -99 AND 99 ,
       DOB DATE FORMAT ‘MMMbDDbYYYY’,
       Sex CHAR(1) UPPERCASE,
       Race CHAR(1) UPPERCASE,
       MStat CHAR(1) UPPERCASE,
       EdLev BYTEINT FORMAT ‘Z9’ BETWEEN 0 AND 22,
       HCap BYTEINT FORMAT ‘Z9’ BETWEEN -99 AND 99 )
       UNIQUE PRIMARY INDEX( EmpNo ) ;
set record unformatted;
define
       delim0(char(1)),
       EmpNo(char(9)), delim1(char(1)),
       Name(char(12)), delim2(char(1)),
       DeptNo(char(3)), delim3(char(1)),
       PhoneNo(char(4)), delim4(char(1)),
       JobTitle(char(12)), delim5(char(1)),
       Salary(char(9)), delim6(char(1)),
       YrsExp(char(2)), delim7(char(1)),
       DOB(char(11)), delim8(char(1)),
       Sex(char(1)), delim9(char(1)),
       Race(char(1)), delim10(char(1)),
       MStat(char(1)), delim11(char(1)),
       EdLev(char(2)), delim12(char(1)),
       HCap(char(2)), delim13(char(1)),
       newlinechar(char(1))
file=insert.input;
show;
begin loading employee errorfiles error_1, error_2;
insert into employee (
       :EmpNo,
       :Name,
       :DeptNo,
       :PhoneNo,
       :JobTitle,
       :Salary,
       :YrsExp,
       :DOB,
       :Sex,
       :Race,
       :MStat,
       :EdLev,
       :HCap
);
end loading;
logoff;