Transactioon Max Unit Number Stored Procedure

Submitted by mikehostetler on Thu, 04/26/2007 - 08:48

<?php
--
-- Transaction Maximum Unit Number Stored Procedure
--

USE <

code>cics_app</code>;

DROP PROCEDURE IF EXISTS Transaction_MaxUnitNumber;

DELIMITER |
CREATE PROCEDURE Transaction_MaxUnitNumber ()
BEGIN
  DECLARE unit_number INT;

 

SELECT
        MAX(<code>transaction</code>.<code>unit_number</code>) INTO unit_number
FROM
       <code>transaction</code>;

   

SELECT unit_number;
END;
|
DELIMITER ;
?>
Taxonomy upgrade extras: 
mysql
cics
mysqli
stored procedure