SQLJ program question ....

[Raquel]

ok, this is a SQL program program that runs fine. What does it mean to
have iterator declared outside the class declaration (from a Java
perspective, what are we doing here??)...I was under the impression
that import statements were the only statements that could come before
the class statement.

import java.sql.*;
import sqlj.runtime.*;
import sqlj.runtime.ref.*;
#sql iterator Named_Iterator(String lastname);

class sqlj2
{
public static void main(String[] args) throws Exception
{
Named_Iterator namedItr = null;
String data = "jdbc:db2://localhost:50000/SAMPLE";
Class.forName("com.ibm.db2.jcc.DB2Driver");
Connection conn = DriverManager.getConnection(data,"user","passwd");
DefaultContext Ctx = new DefaultContext(conn);
DefaultContext.setDefaultContext(Ctx);

#sql namedItr = {SELECT LASTNAME FROM db2admin.EMPLOYEE WHERE
WORKDEPT = 'A00'};
while (namedItr.next())
{
System.out.println("Lastname is: " + namedItr.lastname());
}
namedItr.close();
}
}

TIA
Raquel.