Fastload Utility

Tools
Enthusiast

Fastload Utility

Hi friends...

plz clear my doubt...

Fastload utility runs in 2 modes

1.Interactive mode

2.Batch mode

can u plz give me brief explain abt these 2 modes and give an example...
3 REPLIES
Enthusiast

Re: Fastload Utility

Well i can give details about batch mode...
1.Fastload utility is used to load large amount of data into tables. Fastload works at very high speed. The restriction with fast load is that the table in which the data is to be loaded should be empty. Fastload can load data from multiple files into a single table.
2.It works in two phases ,
Phase 1: Data Acquisition Phase
In the data acquisition phase, data is written from the file to the AMP. AMP is a logical storage unit in Teradata architecture. Data is not written to the disk in this phase.
So to load data from multiple source files into 1 target table, this phase can be carried out multiple times. After collecting data from all the files, phase 2 should be executed. This will write the data to the disk.
Phase 2: Data Loading Phase
Phase 2 writes data to the disk. It releases the locks acquired in phase 1 and deletes the empty error tables.
3.Sample Batch FastLoad Script,

BEGIN LOADING DBS.TABL_NAME
ERRORFILES DBS.TABL_NAME_ERR1
DBS.TABL_NAME_ERR1;

DEFINE
FLD_ONE (CHAR(18))
,FLD_TWO (INTEGER)
,..
,..

DDNAME=INFILE;

INSERT INTO DBS.TABL_NAME
( FLD_ONE = :FLD_ONE
,...
,...
);

END LOADING;
QUIT;

About Interactive mode i am not much aware, some one out here can give more details about it.

Regards,
Ravindra
Enthusiast

Re: Fastload Utility

Thank you Ravindra..

how can we know is it in batch mode or interactive mode?

which one can we use mostly?

Thanks and Regards
Anil Reddy
Senior Apprentice

Re: Fastload Utility

Hi Anil,
interactive mode:
start FastLoad/BTEQ/Mload from command line and then type in all the commands.

batch mode:
fastload out

Just search the FastLoad manual for "interactive".

Dieter