can anyone tell me why i get the error

'SQL command not properly ended'

this sql was lifted directly from a Sybase database and seems to work OK there


update billing_update_items
set archive_flag = p_flag
from billing_update_items, dummy_billings_dets
where billing_update_items.service_id = p_service
and billing_update_items.class_id = p_class
and billing_update_items.update_type = 1
and billing_update_items.billing_det_id = dummy_billings_dets.id
and dummy_billings_dets.txs_date >= p_start_date
and dummy_billings_dets.txs_date <= p_end_date
and archive_flag <> p_flag;
COMMIT;

tia
mark.