There are a number of reasons why this will not work:

First, "INSERT INTO <tablename>" is not a valid statement, because there is nothing specified to insert into the table at all. If you haven't truncated your code before putting it here you have to correct that.

Second, i am not sure what your loop is supposed to do, but it definitely does soething else.

Code:

filename=userreport.txt
while IFS=, read -r filename
do
 ....
done

This loop has no input, because the read-command works differently from what you seem to suspect. If you want to read the file specified by variable "filename", do it like this:

Code:

filename=userreport.txt
while IFS=, read <variablename>
do
 ....
done < "$filename"

Each line in "$filename" will then be assigned to "<variablename>" every turn. You can try this demo code to see how it works:

Code:

filename=userreport.txt
while IFS=, read currentline ; do
     print - "line read: $currentline"
done < "$filename"

Next is: you specifiy "IFS", seemingly to split the input line into (comma-separated) pieces. But because you specify only one variable to "read" the whole line gets put into that variable anyway. The way you use it the IFS-specification is superfluous.

When you want to split the input line upon reading it you have to specify more than one variable to be assigned with the "read"-command. The first "field" (everything before the first IFS character) will be assigned the first variable, the second field (everything between the first and second IFS character) will be assigned the second variable and so on. If you specify less variables than there are fields all the remaining fields are getting crammed into the last variable specified. In your case that was everything.

Try the following demo code to see how it works:

Code:

cat - > /tmp/input.for.demo <<EOF
line1,1-field1,1-field2,1-field-3
line2,2-field1,2-field2,2-field-3,2-field4
line3,3-field1,3-field2,3-field-3,3-field4,3-field5
EOF

Code:

#!/usr/bin/ksh
filename=/tmp/input.for.demo
while IFS=, read -r linenr field1 field2 field3 field4 ; do
     print - "new line read --------------------"
     print - "   linenr is: $linenr"
     print - "   field1 is: $field1"
     print - "   field2 is: $field2"
     print - "   field3 is: $field3"
     print - "   field4 is: $field4"
done < "$filename"
exit 0

I hope this helps.

bakunin