반응형
CREATE PROCEDURE PARTS_ON_HAND (IN PARTNUM INTEGER,
OUT COST DECIMAL(7,2),
OUT QUANTITY INTEGER)
EXTERNAL NAME 'parts!onhand'
LANGUAGE JAVA PARAMETER STYLE DB2GENERAL;
CallableStatement stpCall ;
String sql = "CALL PARTS_ON_HAND ( ?,?,? )" ;
stpCall = con.prepareCall( sql ) ; /* con is the connection */
stpCall.setInt( 1, variable1 ) ;
stpCall.setBigDecimal( 2, variable2 ) ;
stpCall.setInt( 3, variable3 ) ;
stpCall.registerOutParameter( 2, Types.DECIMAL, 2 ) ;
stpCall.registerOutParameter( 3, Types.INTEGER ) ;
stpCall.execute() ;
variable2 = stpCall.getBigDecimal(2) ;
variable3 = stpCall.getInt(3) ;
반응형
'보관함' 카테고리의 다른 글
DB2] 참조 (0) | 2020.12.14 |
---|---|
DB2 cusror사용 (0) | 2020.12.14 |
db2 함수모음 (0) | 2020.12.14 |
이완용 인물백과사전 (0) | 2020.12.13 |
강예빈 인물백과사전 (0) | 2020.12.06 |