Hi , I have a .txt file in the below format:

BARRID|SEDOL|SEAQ|EXSTAT|NAME
AAD1|000163|ASW|AAACZP| ASW HOLDINGS PLC
AAG1|000445|ANL|ABAAFK| ABBEY NATIONAL
AAG2|000643|ANLA|-999| ABBEY NATIONAL PRF

I want to load this data into the db2 database,i am using sqlloader for that.


I have created the control file but donot know how far it is correct as i am not aware of executing the sqlloader.

LOAD DATA
INFILE "C:\VCSTEST\testdata.txt"
BADFILE "C:\VCSTEST\testdata_bad.bad"
INTO TABLE ccp
WHEN (BARRID!='BARRAGER')
FIELDS |
TRAILING NULLCOLS
( BARRID "'GER'||UPPER(:BARRID)",
SEDOL CHAR,
SEAQ CHAR,
EXSTAT CHAR,
NAME CHAR,
)

do i need the .sql file that describes the table structure in the database.

1. Can anybody give me a sample of contol file and tell me what other supporting filies i have to make to load the data.

2. Also please tell me the command to execute the sqlloader for loading the date.

3. Kindly provide me any link that is useful for this purpose.

Regards
Anshul