SQL return codes: Difference between revisions
wikademia>Mike.lifeguard m restore current version |
external link |
||
| Line 1: | Line 1: | ||
'''SQL | '''SQL return codes''' are used for the diagnosis of programming failures as a result of SQL calls by [[w:en:IBM DB2|DB2]] [[w:en:computer program|programs]]. An important feature of DB2 programs is the error processing. The error diagnostic containing the SQL return code is held in the field '''SQLCODE''' within the DB2 [[w:en:SQLCA|SQLCA]] block. | ||
== SQLCA == | == SQLCA == | ||
| Line 71: | Line 71: | ||
+304 Value cannot be assigned to this host variable because it is out of range. | +304 Value cannot be assigned to this host variable because it is out of range. | ||
+802 The null indicator was set to -2 as an arithmetic statement didn't work. | +802 The null indicator was set to -2 as an arithmetic statement didn't work. | ||
==External links== | |||
* A [http://www.theamericanprogrammer.com/programming/sqlcodes.shtml more extensive list] of the codes | |||
[[category:SQL]] | [[category:SQL]] | ||