×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
Is there a list of possible/likely SQL state codes for various SQL
statements?
Basically looking for the SQL equivilent of CL's
Error messages for CHGLIBL
*ESCAPE Messages
CPF2106 Library list not available.
CPF2110 Library &1 not found.
CPF2113 Cannot allocate library &1.
CPF2176 Library &1 damaged.
CPF2182 Not authorized to library &1.
CPF2184 Library list not replaced.
For example,
DROP TABLE
If I expect the table to possible not be there, I'd check for SQLSTATE =
d NOT_FOUND...
d c const('01532')
d UNDEFINED_OBJECT_NAME...
d c const('42704')
(not sure which actually gets set )
In particular, I'm curious if
SET SCHEMA
and
COMMIT
could return any warning codes.
I'm also using CREATE TABLE and UPDATE.
For the CREATE TABLE, I'm checking for
d CREATED_NOT_JOURNALED...
d c const('01567')
Thank you,
Charles
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
