DB2 Universal Database for iSeries SQL Reference

Syntax

Click to skip syntax diagram
                                 .-VALUE-.
>>-+--------+-SIGNAL-+-SQLSTATE--+-------+--sqlstate-string-constant-+-->
   '-label:-'        '-condition-name--------------------------------'
 
>--+--------------------+--------------------------------------><
   '-signal-information-'
 
signal-information:
 
          .-,-----------------------------------------------------------.
          V                                                             |
|--+-SET----+-MESSAGE_TEXT-------+-- = --+-SQL-variable-name----------+-+-+--|
   |        +-CONSTRAINT_CATALOG-+       +-SQL-parameter-name---------+   |
   |        +-CONSTRAINT_SCHEMA--+       '-diagnostic-string-constant-'   |
   |        +-CONSTRAINT_NAME----+                                        |
   |        +-CATALOG_NAME-------+                                        |
   |        +-SCHEMA_NAME--------+                                        |
   |        +-TABLE_NAME---------+                                        |
   |        +-COLUMN_NAME--------+                                        |
   |        +-CURSOR_NAME--------+                                        |
   |        +-CLASS_ORIGIN-------+                                        |
   |        '-SUBCLASS_ORIGIN----'                                        |
   '-(--diagnostic-string-constant--)-------------------------------------'
 
 


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]