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');
[download]

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});
[download]

This seems too complex - for just wanting to use sysdate.