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.
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL