Thread: ANSI error messages

Is there a list of ANSI return code and error messages somewhere? I haven't
found anything yet by grep'ping through the SQL files Tom send me. All I
know is (and that was inside these files too) that NOT FOUND is 100.

Any ideas?

Michael
--
Dr. Michael Meskes, Project-Manager    | topsystem Systemhaus GmbH
meskes@topsystem.de                    | Europark A2, Adenauerstr. 20
meskes@debian.org                      | 52146 Wuerselen
Go SF49ers! Go Rhein Fire!             | Tel: (+49) 2405/4670-44
Use Debian GNU/Linux!                  | Fax: (+49) 2405/4670-10

Michael,

The SQLSTATE codes appear in section 22 of SQL 92.  See
  http://csf.colorado.edu/local/sql/22_status.txt

Apparently, the SQLCODE values are deprecated.

Michael
csf@moscow.com

 :}Is there a list of ANSI return code and error messages somewhere? I haven't
 :}found anything yet by grep'ping through the SQL files Tom send me. All I
 :}know is (and that was inside these files too) that NOT FOUND is 100.
 :}
 :}Any ideas?
 :}
 :}Michael
 :}--
 :}Dr. Michael Meskes, Project-Manager    | topsystem Systemhaus GmbH
 :}meskes@topsystem.de                    | Europark A2, Adenauerstr. 20
 :}meskes@debian.org                      | 52146 Wuerselen
 :}Go SF49ers! Go Rhein Fire!             | Tel: (+49) 2405/4670-44
 :}Use Debian GNU/Linux!                  | Fax: (+49) 2405/4670-10
 :}

Michael Yount writes:
> The SQLSTATE codes appear in section 22 of SQL 92.  See
>   http://csf.colorado.edu/local/sql/22_status.txt
>
> Apparently, the SQLCODE values are deprecated.

Thanks. Found them. Since we do not have SQLSTATE yet, I worry about SQLCODE
only.

Michael

--
Dr. Michael Meskes, Project-Manager    | topsystem Systemhaus GmbH
meskes@topsystem.de                    | Europark A2, Adenauerstr. 20
meskes@debian.org                      | 52146 Wuerselen
Go SF49ers! Go Rhein Fire!             | Tel: (+49) 2405/4670-44
Use Debian GNU/Linux!                  | Fax: (+49) 2405/4670-10