Hi all, I am trying to load data from a text file to my table called term_details,I had given the following query to create and load .But its showing error while executing dataload command,errors are
---- Error ------------------------------- Auto Commit: On, SQL Mode: Internal, Isolation Level: Committed Syntax error or access violation;-3005 POS(1) Invalid SQL statement. dataload table Term_Details ignore duplicates infile 'D:\Rupesh\terms.txt' *************** Commands I used ************** create table Term_Details (Term varchar(20) primary key,Id int not null,Details varchar(3000) default 'none') dataload table Term_Details ignore duplicates infile 'D:\Rupesh\terms.txt' Regards Rupesh Database Administrator iNetFrame Technologies
