in reply to Re: DBD::ODBC not support
in thread DBD::ODBC not support
i am running query like this
my $SQL = "UPDATE kcrei_batch_job_history SET rows_added = ?, status = 'C', stop_datetime = getdate(), stop_tran_seq_nbr = ?, elapsed_time_hh = datediff(hh, convert(dat +etime,?), getdate()), elapsed_time_mm = datediff(mi, convert(dat +etime,?), getdate()), elapsed_time_ss = datediff(ss, convert(dat +etime,?), getdate()) WHERE master_job_no = ? AND master_job_sub_no = ?";
my $sth = $dbh->prepare( $SQL ) or die "Couldn't prepare statement: " . $dbh->errstr; eval{ $sth->execute($_[1], $hdr_tran_seq_nbr, $loader_start_time, $loader_start_time, $loader_start_time, $master_job_no, $_[0] ); $sth->finish(); }; if( $@ ) { outputErrorMessage( "$@" ); outputErrorMessage( "$sth->{Statement}" ); }
hi mje in this way i am running my query
|
---|
Replies are listed 'Best First'. | |
---|---|
Re^3: DBD::ODBC not support
by mje (Curate) on May 12, 2010 at 10:49 UTC |
In Section
Seekers of Perl Wisdom