TechTip: Simple Error Handling in Embedded SQL

[MCWebsite.Staff]

** This thread discusses the article: TechTip: Simple Error Handling in Embedded SQL **
** This thread discusses the Content article: TechTip: Simple Error Handling in Embedded SQL0

[Guest.Visitor]

TechTip: Simple Error Handling in Embedded SQL

** This thread discusses the article: TechTip: Simple Error Handling in Embedded SQL **
Hope there is more to this article next time. Becuase it seems to me that there should be a little more explanation to sqlcode and sqlstate.

[fm_hunter@yahoo.com]

TechTip: Simple Error Handling in Embedded SQL

** This thread discusses the article: TechTip: Simple Error Handling in Embedded SQL **
80% of this article discusses the way you should not monitor for errors in your embedded SQL, and then one short paragraph at the end declaring the way you should do it. Peculiar to say the least. You can look up the possible values for both codes on the IBM site, however, but for a simple example, you can check SQLCOD for any value other than zero after your program executes embedded SQL. If it isn't zero, then your SQL statements didn't find any records.

[Guest.Visitor]

TechTip: Simple Error Handling in Embedded SQL

** This thread discusses the article: TechTip: Simple Error Handling in Embedded SQL **
For some reason you have to log in to see the complete article.