WinBatch Tech Support Home

Database Search

If you can't find the information using the categories below, post a question over in our WinBatch Tech Support Forum.

TechHome

ODBC
plus

Can't find the information you are looking for here? Then leave a message over on our WinBatch Tech Support Forum.

SQL SUCCESS WITH INFO


Question:

Can someone remind me why we need to check the return code against both @qSuccess and @qSuccessInfo? Why the two values? What's the difference between them?

Answer:

@Success is like "Hey It worked"

@SuccessInfo is "It worked, but there is something you better know about"

Not sure but qError might be able to fish out the information if 2SuccessInfo is returned.

In my experience, the @SuccessInfo is benign [in terms of error]. It often is returned when fetching data with 'prepared' statements, the INFO probably reminding you it is prepared; or it may inform you that some 'null' values were returned; or it may have a timestamp 'hiccup'. Worse case might be an ODBC timeout, where everything was returned save the last row of data.

You might also see it commonly when you try to set a handle attribute which the driver doesn't support, or which is incompatible with some other attribute you set, and the driver manager changes the attributes from the ones you set. The diagnostic description is something like "attribute changed".


Article ID:   W16344
File Created: 2017:07:28:13:58:34
Last Updated: 2005:02:18:12:19:55