Example 1: Delete department (DEPTNO) 'D11' from the DEPARTMENT table.
DELETE FROM DEPARTMENT WHERE DEPTNO = 'D11'
Example 2: Delete all the departments from the DEPARTMENT table (that is, empty the table).
DELETE FROM DEPARTMENT
Example 3: Use a Java(TM) program statement to delete all the subprojects (MAJPROJ is NULL) from the PROJECT table on the connection context 'ctx', for a department (DEPTNO) equal to that in the host variable HOSTDEPT (java.lang.String).
#sql [ctx] { DELETE FROM PROJECT WHERE DEPTNO = :HOSTDEPT AND MAJPROJ IS NULL };
Example 4: Code a portion of a Java program that will be used to display retired employees (JOB) and then, if requested to do so, remove certain employees from the EMPLOYEE table on the connection context 'ctx'.
#sql iterator empIterator implements sqlj.runtime.ForUpdate ( ... ); empIterator C1; #sql [ctx] C1 = { SELECT * FROM EMPLOYEE WHERE JOB = 'RETIRED' }; #sql { FETCH C1 INTO ... }; while ( !C1.endFetch() ) { System.out.println( ... ); ... if ( condition for deleting row ) { #sql [ctx] { DELETE FROM EMPLOYEE WHERE CURRENT OF C1 }; } #sql { FETCH C1 INTO ... }; } C1.close();
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.