Want a Simple Batch Mode Fastload example.

Tools & Utilities
Enthusiast

Want a Simple Batch Mode Fastload example.

Hi all terdata gurus

I want a simple batch fastload script to load the foll. values stored in a text file named and load it into an empty table called

001$sharon$stone
002$demi$moore
003$drew$barrymore
004$julia$roberts
005$cameron$diaz
006$homer$simpson

I have created a simple table using the foll. create table statement,

now want to use fastload script in batch mode and load an empty table named
thanx all in advance

rgrds
terdataguy
3 REPLIES
Enthusiast

Re: Want a Simple Batch Mode Fastload example.

sorry gurus,

i forgot to put in the create table statement in the post it is as below,
create table stars (sid int, fname char(20), lname char(20));

thnx all again
Enthusiast

Re: Want a Simple Batch Mode Fastload example.

Try this one!! u may face some syntactical errors!!

.logon <>/ ;

BEGIN LOADING stars
ERRORFILES
ERRORTABLE1,
ERRORTABLE2;

SET RECORD VARTEXT "$" ;
DEFINE
sid (VARCHAR(10)),
fname (VARCHAR(20)),
lname (VARCHAR(20))

FILE=DDNAME or filelocation;

INSERT INTO stars
VALUES (
:sid ,
:fname,
:lname
);

.END LOADING;
.LOGOFF;
Enthusiast

Re: Want a Simple Batch Mode Fastload example.

hi kondal guru,

thnx for the fastload script it worked without any probs.

rgrds
teradataguy