Hello,
The script below contain by error a ";" before the where close
On execution it continue and does commit !!!
It there a way to stop execution when there is a unknow command ?
thanks
WHENEVER OSERROR exit 99 ROLLBACK
WHENEVER SQLERROR exit SQL.SQLCODE ROLLBACK
UPDATE tablecp_values
SET endValidity = TO_DATE('30/11/2014', 'dd/MM/yyyy');
where commission='302';
COMMIT;
-->
STANDARD PRE SQL > UPDATE tablecp_values
2 SET endValidity = TO_DATE('30/11/2014', 'dd/MM/yyyy');
1868 rows updated.
STANDARD PRE SQL > where commission='302'
SP2-0734: unknown command beginning "where comm..." - rest of line ignored.
STANDARD PRE SQL >
STANDARD PRE SQL >
STANDARD PRE SQL > COMMIT;
Commit complete.