Help plz in sql loader!!!!

[bhu]

ya thanks i hav already tried in the way u said it works.but i wan to know the reason y its not working wit var

thanks
bhu

[bhu]

wht should i do if i am using var?????

[LKBrwn_DBA]

Why use "var" when you don't need it?
If you do have to use it, then your data lengths are incorrect.
Here is the correct data file to use with your controlfile:

011hello,cd,
011world,im,
013my,name is,

And the controlfile would be:

load data
infile 'c:\ex.dat' "var 3"
truncate into table exam
fields terminated by ',' optionally enclosed by '"'
(col1 char,col2 char)

[bhu]

thank you so much but its working only with this data file. can you please tell me how the data should be.

thanks
bhu

[bhu]

thank you so much i got my query cleared... am getting proper output with out error now...


thanks
bhu