Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 15-04-2009
Member
 
Join Date: Feb 2009
Posts: 47
Where to use "signal" keyword in SQL ?

hello,

I want to ask that where do we use the keyword called " signal " in SQL ? and what is the importance of this keyword ? I am sure many of you would be very well aware of this......can anybody help me with this ?
thnx
Reply With Quote
  #2  
Old 15-04-2009
Member
 
Join Date: Apr 2008
Posts: 1,948
Re: Where to use "signal" keyword in SQL ?

SIGNAL -
With the SIGNAL statement, you can use it to raise an SQLSTATE exception. This statement can only be used within a trigger_body or within the body of an SQL routine, whose language type is SQL.
This statement will cause an SQLSTATE exception to be thrown and propagated back to your program.
You provide the text of the message.

NOTE: The SIGNAL statement rolls back the specific event that activated its trigger and all the changes caused by the trigger, as well as the original SQL statement of the user, which includes all the triggers and cascading actions that it invoked.

Syntax -
signal - The SIGNAL keyword is required as the first word in a SIGNAL statement.

sqlstate_message - The sqlstate_message is an SQL string literal value. You can specify any text they would like. The actual SQLSTATE code will be ZG014 and the SQL error code is 25014.
Reply With Quote
  #3  
Old 15-04-2009
Member
 
Join Date: Feb 2008
Posts: 1,848
Re: Where to use "signal" keyword in SQL ?

The signal keyword is specified under the trigger body. Whenever user triggers the condition ( BEFORE or AFTER ), the action is performed and this action is performed using the signal keyword.....rightly to signal the action when the specific condition triggers.
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Where to use "signal" keyword in SQL ?"
Thread Thread Starter Forum Replies Last Post
Getting "No Signal" message when trying to import old VHS tape files in Creator 2012 Pro Sru S Windows Software 6 16-01-2012 09:39 AM
<input type="button" value="Enregistrer" onclick="location.href=../asp/PRaces.asp"> Luz Software Development 6 18-05-2010 12:27 AM
Monitor showing "no signal" in Compaq Presario CQ5300F Desktop Muses Monitor & Video Cards 5 20-03-2010 09:55 AM
Return keyword does not give value of variable "ast" MKAIF Software Development 5 04-03-2010 07:40 PM
The keyword "static", attributes and methods of class in OOP DotNetUser Software Development 3 05-01-2009 11:37 AM


All times are GMT +5.5. The time now is 09:15 PM.