How to integrate ForUpdate iterator in Development Center

[eric]

Hi,

I would like to build the inParams SQLJ sample procedure from the
Development Center.

if I declare a #sql public iterator SpIterat, the Development Center
complains this should be in a separate file.
if I declare a #sql iterator SpIterat, the Development Center complains the
statements #sql [ctx] updateIterator are not Java ...

My problem is: how do I integrate the ForUpdate iterator ? It should be in a
class that needs to be incorporated into my JAR but I don't see how

Thanks for your help,

Eric
import java.sql.*; // JDBC classes
import java.io.*; // Input/Output classes
import java.math.BigDe cimal; // Packed Decimal class
import sqlj.runtime.*;
import sqlj.runtime.re f.*;

===> sqlj.runtime.Fo rUpdate;
===> #sql public iterator SpIterat implements ForUpdate(doubl e);

#sql context SpContext;

#sql iterator SpServerSalary( double);
#sql iterator SpServerEmploye es(String, String, double);

///////
// SQLj stored procedure is in this class
///////
public class SpServer
{
//*************** *************** *************** *************** *************
// Stored Procedure: inParams
//
// Purpose: Updates salaries of employees in department 'inDepartment'
// using inputs inLowSal, inMedSal, inHighSal as
// salary raise/adjustment values.
//
// Parameters:
//
// IN: inLowSal - new salary for low salary employees
// inMedSal - new salary for mid salary employees
// inHighSal - new salary for high salary employees
// inDepartment - department to use in SELECT predicate
// OUT: (none)
//

//*************** *************** *************** *************** *************
public static void inParams(double inLowSal,
double inMedSal,
double inHighSal,
String inDepartment) // CHAR(3)
throws SQLException
{
String errorLabel = null;
int errorCode = 0; // SQLCODE = 0 unless SQLException occurs

SpContext ctx = null;
double salary;
String cursorName;
SpIterat updateIterator;

// initialize variables
salary = 0;
cursorName = "";

try
{
ctx = new SpContext("jdbc :default:connec tion", false);

errorLabel = "DECLARE ITERATOR";
#sql [ctx] updateIterator = {SELECT CAST(salary AS DOUBLE)
FROM employee
WHERE workdept = :inDepartment};

errorLabel = "FETCH FIRST ROW";
#sql {FETCH :updateIterator INTO :salary};

if (updateIterator .endFetch())
{
// iterator contains no data, so return SQLCODE 100 to client
errorLabel = "100 : NO DATA FOUND";
}
else
{
while (!updateIterato r.endFetch())
{
if (inLowSal > salary)
{
errorLabel = "UPDATE -- LOW CASE";
#sql [ctx] {UPDATE employee SET salary = :inLowSal
WHERE CURRENT OF :updateIterator };
}
else if (inMedSal > salary)
{
errorLabel = "UPDATE -- MEDIUM CASE";
#sql [ctx] {UPDATE employee SET salary = :inMedSal
WHERE CURRENT OF :updateIterator };
}
else if (inHighSal > salary)
{
errorLabel = "UPDATE -- HIGH CASE";
#sql [ctx] {UPDATE employee SET salary = :inHighSal
WHERE CURRENT OF :updateIterator };
}
else
{
errorLabel = "UPDATE -- FINAL CASE";
#sql [ctx] {UPDATE employee SET salary = (salary * 1.10)
WHERE CURRENT OF :updateIterator };
}
#sql {FETCH :updateIterator INTO :salary};
}
}
updateIterator. close();
ctx.close();
}
catch (SQLException sqle)
{
if( ctx != null )
{
try { ctx.close(); } catch( Exception e ) {}
}

errorCode = sqle.getErrorCo de();
if (errorLabel.equ alsIgnoreCase(" 100 : NO DATA FOUND"))
throw new SQLException(sq le.getMessage() );
else
throw new SQLException(er rorCode + " : " + errorLabel + " FAILED");
}
} // inParams
} // SpServer