Stored ProC: Insert Statement

EXEC SQL AT DB_NAME Insert into EMSD_SCHE(JOB_ID, SUBMIT_DATE, MANUAL_SUB, STAFF, ARRIVAL, STATUS)
        VALUES(:in_id, systimestamp, :in_sub, :in_staff, :in_man, :in_stat);
    EXEC SQL AT DB_NAME COMMIT;

Remember to Commit!