Just SQL

Thanks,
Lisa Greetham
Database Administrator, Corporate Internet Group
Bank One




"Richard J Reppert" <[Email Address Removed] 01:04 PM

To
"[Email Address Removed] <[Email Address Removed] <[Email Address Removed] returning an error






Depends on the source language for the stored procedure. What one are you
using?

Richard


On Fri, 31 Jan 2003 08:48:57 -0500, [Email Address Removed] wrote:

>
>Hello. I have written many procedures for MSSQL and Sybase, but not many
>in DB2. I am trying to figure out the best way to return an error
message
>to an application from a stored procedure. In MSSQL there is a
>'raiserror' command. So I could say in a stored procedure..
>
>is @var <>2
> raiserror 'The var is not equal to 2'
>
>The application would then know how to handle whatever message I sent it.
>I am thinking I should just probably use RETURN, but I am not sure. What
>are your thoughts?
>
>Thanks,
>Lisa Greetham
>Database Administrator, Corporate Internet Group
>Bank One
>
>
>
>This transmission may contain information that is privileged,
confidential and/or exempt from disclosure under applicable law. If you
are not the intended recipient, you are hereby notified that any
disclosure, copying, distribution, or use of the information contained
herein (including any reliance thereon) is STRICTLY PROHIBITED. If you
received this transmission in error, please immediately contact the sender
and destroy the material in its entirety, whether in electronic or hard
copy format. Thank you.
>
>
>---------------------------------------------------------------------
>PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
>To unsubscribe, e-mail: db2udbdba-[Email Address Removed] additional commands, e-mail: db2udbdba-[Email Address Removed] J Reppert
Sumx Inc.
972-355-8004 x102
972-355-8048 fax



---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
To unsubscribe, e-mail: db2udbdba-[Email Address Removed] additional commands, e-mail: db2udbdba-[Email Address Removed] transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you.

DB2 & UDB email list listserv db2-l LazyDBA home page