topic Re: Customised Message for incorrect password error in Developers

Customised Message for incorrect password error

NN — Fri, 14 Jan 2011 11:20:29 GMT

Guys,
My stored process is one where my user enters his user name and password to be used in a pass through query.
I have blocked the error log for the user and so.
My problem is that there could be a connection issue because of which an error can occur or The user might have entered an incorrect password.
Will i be able to customise and print an error message on each situation.

I.e. will i be able to identify that my error was due to an incorrect password or due to a connectivty issues.

Please Guide

Re: Customised Message for incorrect password error

Vince_SAS — Mon, 17 Jan 2011 16:12:01 GMT

You can check return codes in SAS and then handle error conditions. As a start, take a look at the information presented here:

http://support.sas.com/documentation/cdl/en/sclref/59578/HTML/default/a000149936.htm

The techniques discussed there should work in DATA Step code.

Vince DelGobbo
SAS R&D

Re: Customised Message for incorrect password error

NN — Wed, 19 Jan 2011 12:23:59 GMT

Vince,
Thanks for directing in the right path.

Found the following macros to be exactly what i required.

&sysdbmsg / &sysdbrc / &sqlxmsg / &sqlxrc.