Kbase P68437: How to convert Decimal object value returned from SQL-92 to
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
2/24/2004 |
|
Status: Unverified
GOAL:
How to convert Decimal object value returned from SQL-92 to a primitive float value within a stored procedure
FACT(s) (Environment):
Progress 9.x
FIX:
Example stored procedure text:
CREATE PROCEDURE spr_float_test (
)
RESULT(
afloat FLOAT,
aDeci DECIMAL
)
BEGIN
StringBuffer myQry = new StringBuffer("") ;
myQry.append("select ftest, fDeci from support");
SQLCursor myCur = new SQLCursor(myQry.toString());
myCur.open();
while (myCur.found ()) {
myCur.fetch();
float myfloat_value = ((java.math.BigDecimal)(myCur.getValue(2,DECIMAL))).floatValue();
Float myFloat = new Float(myfloat_value);
SQLResultSet.set(1,myFloat);
SQLResultSet.set(2, (java.math.BigDecimal)(myCur.getValue(2,DECIMAL)) );
SQLResultSet.insert();
}
myCur.close();
END