====== SIGNAL Statement - PL/HQL Reference======

SIGNAL statement raises a user-defined condition (exception).

**Syntax**:

<code language="sql">
SIGNAL condition_name;
</code>

**Example:**

Raise a condition if the number of rows is not equal to the specified number:

<code language="sql">
DECLARE cnt INT DEFAULT 0; 
DECLARE wrong_cnt_condition CONDITION;

DECLARE EXIT HANDLER FOR wrong_cnt_condition
  PRINT 'Wrong number of rows';  

SELECT COUNT(*) INTO cnt FROM TABLE (VALUES (1,2));

IF cnt <> 1 THEN
  SIGNAL wrong_cnt_condition;
END IF;
</code> 

**Compatibility**: IBM DB2, Teradata and MySQL

**Version**: PL/HQL 0.3.1

**See also:**
  * [[error-handling|Error Handling]]
  * [[declare-condition|DECLARE CONDITION]]
  * [[declare-handler|DECLARE HANDLER]]
  * [[sqlcode|SQLCODE]]
  * [[sqlstate|SQLSTATE]]
  * [[get-diagnostics|GET DIAGNOSTICS]]
  * [[resignal|RESIGNAL]]