I am trying to load from file to table.Below is the syntax used.

load client from 'c:\Usha\stage.del' of del modified by noheader COLDEL0x1F
method P (1,2)
insert into e.emp(
name ,
id ,

My problem is column are not getting read based on delimiter .Since my First column is character(255),Almost data of 3 column is populated into same column.

Should I specify \307 delimiter in a different way.Please help