load data from .txt file to db2
Hi , I have a .txt file in the below format:
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.
INTO TABLE ccp
( BARRID "'GER'||UPPER(:BARRID)",
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.
-- Android Development Center
-- Cloud Development Project Center
-- HTML5 Development Center
-- Windows Mobile Development Center