Main menu

Transaction Max Batch Number Stored Procedure

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

This is somewhat simplistic. The reason I implemented a simple MAX() query is to move towards centralizing all of my custom SQL into stored procedures.

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

USE <

code>cics_app</code>;

DROP PROCEDURE IF EXISTS Transaction_MaxBatchNumber;

DELIMITER |
CREATE PROCEDURE Transaction_MaxBatchNumber ()
BEGIN
   DECLARE batch_number INT;

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

   

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