Sybase sqldbcode values

Can anyone guide me to all the sqldbcode values returned from the Sybase server? I need to code for those values in pfc - dberror event - so that I can display some meaningful errors to the users.
Who is Participating?
diasroshanConnect With a Mentor Commented:

As far as i understand, the above 2 links shud serve your purpose, since ur looking specific for Sybase Database.
SQLCodes in the Sybase link are same as the sqldbcodes of PB. But vendor specific. Oracle will have it different.

ill put the screenshots from both the links to illustrate my point.

For eg.
Powebuilder sqldbcode = -195
As per Sybase -195 is ---> "Column '%1' in table '%2' cannot be NULL"

If u are still facing problems, give me an example of error u want to trap and ill explain with these 2 links.

4LearningAuthor Commented:
Thankyou diasroshan, but my original question was asking about sqldbcodes and NOT sqlcodes. So the link really does not help.
I need to quote in my script the action to be taken on  certain sqldbcodes values - this happens when sqlcode is negative.
And since sqldbcode is vendor specific, the error codes from one vendor will be different from another.
Hope someone is able to help me out with this.

4LearningAuthor Commented:
Thanks diasroshan for the info. I didnt know that in case of Sybase, the sqlcode and sqldbcode values are the same.

Thanks also to sandeep_patel for the link.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.