select SNO,AGE from TEST where AGE > ? order by AGE

set :Str1 = 'select SNO,AGE from TEST where AGE > ? order by AGE';
set :AGE0 = 33;

prepare Stmt1 from :Str1;

declare curs1 cursor from Stmt1;

Open curs1 using :AGE0

Fetch curs1 into :SNO, :AGE

package com.ibm.itso.sg246435.jdbc;

import java.math.BigDecimal;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
/**
* Sample test program to retrieve all employees
* in the EMP sample tables whose salary is in
* a given range.
*
* @author Lenny77
*/
public class Get_RS {
/** JDBC URL to the database. */
private static final String url = "jdbc:db2://wtsc63.itso.ibm.com:33756/DB7Y"
+ ":retrieveMessagesFromServerOnGetMessage=TRUE;";  

/** User name to connect to the database. */
private static final String user = "lenny77"; // your user

/** Password for the database connection. */
private static final String password = "pob7777";

public static void main(String[] args) {
Connection conn = null;
PreparedStatement stmt = null;
ResultSet rs = null;
try {
// Load the JDBC driver.
Class.forName("com.ibm.db2.jcc.DB2Driver"); 
// Connect to the database server.
conn = DriverManager.getConnection(url, user, password);  
// Prepare the SELECT statement.
stmt = conn.prepareStatement(  
"select SNO, AGE from TEST where AGE > ? order by AGE");

// Set parameters for the SELECT statement.
stmt.setBigDecimal(1, new BigDecimal(33));  

// Execute the query to retrieve a ResultSet.
rs = stmt.executeQuery(); 

// Iterate over the ResultSet.
while (rs.next()) { 
String SNO = rs.getString(1); // SNO
BigDecimal AGE= rs.getBigDecimal(2); // AGE
System.out.println(SNO + ", " + AGE);
}
} catch (SQLException e) {
// Print exceptions to the console.
System.err.println(e.getMessage());
} catch (Exception e) {
System.err.println(e);
} finally {
// Clean up.
try {
if (rs != null) rs.close();
if (stmt != null) stmt.close();
if (conn != null) conn.close();
} catch (SQLException ignored) {
}
}
}