My first thread finger command issue was resolved. I have sent other message with subject "loading text file into table" with followng details

I have text file like below



Code:
Code:userreport.txt sinlgae34f,n,Mon,Aug,19,,2013,onggi11ggi11,n,Thu,Jul,12,,2012,onhca05hca05,n,Mon,Apr,4,,2011,on,r45f vr45fv,n,Fri,Feb,7,2014,16:5e43vg,4er34,n,Tue,Aug,21,,2012,onrt4566rt4566,n,Tue,Nov,12,2013,12:
I would like to load this userreport.txt file into table.

I used two program



Code:
program1: #!/bin/kshload datainfile 'userreport.txt'INSERT INTO lastlogonFIELDS TERMINATED BY ','(useridDayMonthDateyear )



Code:
Program 2: #!/bin/kshfilename=userreport.txtwhile IFS=, read doINSERT INTO lastlogondone

when I compile program 1: I am getting below error



Code:
loaddata.ksh[2]: load: not found+ infile userreport.txtloaddata.ksh[3]: infile: not found+ INSERT INTO lastlogonloaddata.ksh[4]: INSERT: not found+ FIELDS TERMINATED BY ,loaddata.ksh[5]: FIELDS: not found+ useridloaddata.ksh[7]: userid: not found+ Dayloaddata.ksh[8]: Day: not found+ Monthloaddata.ksh[9]: Month: not found+ Dateloaddata.ksh[10]: Date: not found+ yearloaddata.ksh[11]: year: not found


In program 2: not inserting into text file



Code:
+ filename=userreport.txt+ read+ IFS=,+ INTO lastlogonloaddata1.ksh[5]: INTO: not found

I want to inset .txt file into my new table.