SQLcode and Sql states

sandhya.karanam · #1 (**permalink**) 11-27-09, 00:46

HI,

When i know a sqlstate value and i want to know the corresponding sqlcode values, do we have any command for that

Please let me know if any one finds it

Sandhya

stolze · #2 (**permalink**) 11-27-09, 09:37

No, because multiple SQLCODEs may map to the same SQLSTATE.

Marcus_A · #3 (**permalink**) 11-27-09, 09:49

SQLSTATE was an attempt to standardize error codes accross all relational database products (including non-IBM products).

sandhya.karanam · #4 (**permalink**) 11-28-09, 06:41

Thank u, so u mean to say there is no other way to get the sqlcode associated to a certain sqlstate...

Marcus_A · #5 (**permalink**) 11-28-09, 11:14

Quote:

Originally Posted by sandhya.karanam

Thank u, so u mean to say there is no other way to get the sqlcode associated to a certain sqlstate...

You can search the PDF manual (SQL Messages Vol 2) for each occurance of a SQLSTATE to see if it comes up more than once.

stolze · #6 (**permalink**) 11-30-09, 08:42

Quote:

Originally Posted by sandhya.karanam

Thank u, so u mean to say there is no other way to get the sqlcode associated to a certain sqlstate...

There is no "sqlcode associated to a certain sqlstate" - it is the other way around: each SQLCODE has an associated SQLSTATE. This is a 1:n mapping between SQLCODE and SQLSTATE.

Internet Services

Web Development

Digital Marketing

Consumer Tech