I am having a problem with creating a stored procedure.

The premise underwhich we are operating is the following:
We are working with two tables. The first table simply stores an integer value representing the last used value. The second table lists ranges of integers which have already been allocated in a legacy system. This table has two columns representing the various starting and ending values for these ranges.
...

Hi All,

Sorted out the problem. I started from scratch, and pieced it all together properly. Working code:

CREATE PROCEDURE SDE.PROCEDURE1 (OUT newUniqueKey BIGINT)
------------------------------------------------------------------------
-- SQL Stored Procedure
------------------------------------------------------------------------
P1: BEGIN
DECLARE lastUniqueKey BIGINT DEFAULT -9999;...

I am battling to get a stored procedure to build:

I have a stored procedure working in SQL Server 2000, and now need to port it to DB2. I will be accessing the stored procedure via VB.NET. The stored procedure reads a value from a table, increments the value by 1 and writes it back into the table. The table is called LOADER.CAD_AT_L AST_UNIQUE_ID, and the field is LASTKEY. When I try to build the procedure I get the following message:...