Got it working with Class DBI - had to revert to Ima::DBI set_sql in the dbi subclass against the table.
Code in the subclass
SDU::DBI_AJ->set_sql('InsertInfoAJ',
'INSERT into sdu_active_jobs(jobid,job_name,target_device,customer,
+ start_date,status)
VALUES (?,?,?,?,SYSDATE,?)','Main');
Code in the calling class:-
$create_job = SDU::DBI_AJ->sql_InsertInfoAJ;
$rv = $create_job->execute($cr{jobid},
$cr{job_name},
$cr{target_device},
$cr{customer},
$cr{status});
This seems too complex - for just wanting to use sysdate.