After job subroutine (bcp fail)

[monaz]

Hi All ,

I am using an after job subroutine for insertion of records into table using an unix script..

The below script is wrritten
#! /usr/bin/ksh
# Load into od_trans_map_output table for HALO Transaction Mapping

isql -Uwindevdbo -Pwindevdbo12 -SIISS1 <<-EOI1
use odstest
go
truncate table od_trans_map_output
go
EOI1
bcp odstest..od_trans_map_output in $1 -Uwindevdbo -Pwindevdbo12 -SIISS1 -c -t ","


Director i getting the below warnning and insertion is not happening

Starting copy... Unexpected EOF encountered in BCP data-file. bcp copy in failed

the sequential file is passed to the script as the parameter

The Sequential file set up is done as below

Record level- Record delimiter -Unix newline
Field defaults- delimiter- Comma

Please guide me if i have to do some other settings....