The IBM® Data Server Driver for JDBC and SQLJ includes support for the ParameterMetaData interface. The ParameterMetaData interface contains methods that retrieve information about the parameter markers in a PreparedStatement object.
To invoke ParameterMetaData methods, you need to perform these basic steps:
Connection con;
ParameterMetaData pmtadta;
int mtadtacnt;
String sqlType;
…
pstmt = con.prepareStatement(
"UPDATE EMPLOYEE SET PHONENO=? WHERE EMPNO=?");
// Create a PreparedStatement object 1
pmtadta = pstmt.getParameterMetaData(); 2
// Create a ParameterMetaData object
mtadtacnt = pmtadta.getParameterCount(); 3
// Determine the number of parameters
System.out.println("Number of statement parameters: " + mtadtacnt);
for (int i = 1; i <= mtadtacnt; i++) {
sqlType = pmtadta.getParameterTypeName(i); 4
// Get SQL type for each parameter
System.out.println("SQL type of parameter " + i " is " + sqlType);
}
…
pstmt.close(); // Close the PreparedStatement