#!/usr/bin/ksh IFS=',' while read val1 val2 rest do sqlstmt="update Tablename set Varnum1 = $val2 where Date = '$val1' and UId = 1" print $sqlstmt done < $1