// The EMPLOYEEJOB procedure accepts an employee number and returns a job
// code or null value to an output parameter.
//
// See http://trafodion.apache.org/docs/spj_guide/index.html#employeejob-procedure
// for more documentation.
public static void employeeJob( int empNum
			      , java.lang.Integer[] jobCode
			      ) throws SQLException
{
   Connection conn =
      DriverManager.getConnection( "jdbc:default:connection" ) ;

   PreparedStatement getJobcode = 
      conn.prepareStatement( "SELECT jobcode " 
			   + "FROM trafodion.persnl.employee " 
			   + "WHERE empnum = ?"
			   ) ;

   getJobcode.setInt( 1, empNum ) ;
   ResultSet rs = getJobcode.executeQuery() ; 
   rs.next() ;

   int num = rs.getInt(1) ; 
   if ( rs.wasNull() )
      jobCode[0] = null ;
   else
      jobCode[0] = new Integer(num) ; 

   rs.close() ;
   conn.close() ;

}