This page is part of the book SQL-99 Complete, Really, by Peter Gulutzan & Trudy Pelzer. The authors have graciously allowed us to reproduce the contents of the book here. Because the book is about the SQL-99 standard, the contents of this and other pages in the book may not directly apply to MariaDB. Use the navigation bar to navigate the book.

All CLI functions return a 16-bit value. We refer to this value as the SQLRETURN value because sqlcli.h contains this line:

  typedef SQLSMALLINT SQLRETURN;

In standard SQL there are only six possible SQLRETURN values:

-2"invalid handle".
-1"error".
0"success".
1"success with info".
99"need data".
100"no data".

Programs should check these values, but for space reasons we leave SQLRETURN out of many of our examples.

Comments

Comments loading...