SQL stored procedure on z/OS ....

[Raquel]

This is for SQL stored procedures on OS/390. UDB (for LUW) has a
SIGNAL clause that can be used in SQL Stored procedures. There seems
to be no equivalent on DB2 for OS/390.

For example, I want to roughly emulate the following algorithm on DB2
for OS/390 (don't bother with the syntax):

CREATE PROCEDURE PROC1(IN VAL1, IN VAL2)
IF VAL1 ^= 'A' THEN
SIGNAL SQLSTATE '75089'
SET MESSAGE_TEXT = 'VAL1 CANNOT BE 'A'';
END-IF

With condition handlers (that are available on DB2 for OS/390), I
could not fathom how to accomplish this.

Appreciate inputs on this.

TIA
Raquel.

[Jeroen van den Broek]

Raquel wrote:

This is for SQL stored procedures on OS/390. UDB (for LUW) has a
SIGNAL clause that can be used in SQL Stored procedures. There seems
to be no equivalent on DB2 for OS/390.

For example, I want to roughly emulate the following algorithm on
DB2 for OS/390 (don't bother with the syntax):

CREATE PROCEDURE PROC1(IN VAL1, IN VAL2)
IF VAL1 ^= 'A' THEN
SIGNAL SQLSTATE '75089'
SET MESSAGE_TEXT = 'VAL1 CANNOT BE 'A'';
END-IF

With condition handlers (that are available on DB2 for OS/390), I
could not fathom how to accomplish this.

Appreciate inputs on this.

TIA
Raquel.

Actually, DB2 for z/OS ans OS/390 Version 8 does have the SIGNAL clause.
Have a look at:
http://publib.boulder.ibm.com/infoce...bjnvmstr56.htm

HTH,
Jeroen.