note
Bheema_Tyco
<p> i am running query like this</p>
<code> 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(datetime,?), getdate()),
elapsed_time_mm = datediff(mi, convert(datetime,?), getdate()),
elapsed_time_ss = datediff(ss, convert(datetime,?), getdate())
WHERE
master_job_no = ? AND
master_job_sub_no = ?";</code>
<code>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}" );
}</code>
<p> hi mje in this way i am running my query</p>
839531
839587