SQLSTATE: Difference between revisions

Content deleted Content added
Kelti (talk | contribs)
Incorrect and missleading use of the term 'SQLCODE'
GreenC bot (talk | contribs)
Add {{Unreferenced}} (via noref bot)
Line 1:
{{Unreferenced|date=June 2019|bot=noref (GreenC bot)}}
Programs calling a database which accords to the SQL standard receive an indication about the success or failure of the call. This return code - which is called SQLSTATE - consists of 5 byte. They are divided into two parts: the first and second byte contains a '''class''' and the following three a '''subclass'''. Each class belongs to one of four '''categories''': "S" denotes "Success" (class 00), "W" denotes "Warning" (class 01), "N" denotes "No data" (class 02) and "X" denotes "Exception" (all other classes).