** No of Sessions needed for the load **

SESSIONS 4;

** Records Loaded from 100 to 100000 **

RECORD 100 THRU 100000;

** Till 25 errors the Scipt can be executed

ERRLIMIT 25;

LOGON tdpid/userid,password
DROP TABLE FastTable;
DROP TABLE Error1;
DROP TABLE Error2;

** Table Creation

CREATE TABLE FastTable, NO FALLBACK
   ( ID INTEGER, UFACTOR INTEGER, MISC CHAR(42))
   PRIMARY INDEX(ID);


** Defing the Columns in Text File

DEFINE ID (INTEGER), UFACTOR (INTEGER), MISC (CHAR(42))
   FILE=FileName;
SHOW;

** Fast Load Starts Here

BEGIN LOADING FastTable ERRORFILES Error1,Error2
   CHECKPOINT 10000;
INSERT INTO FastTable (ID, UFACTOR, MISC) VALUES
   (:ID, :MISC);
END LOADING;
LOGOFF;