Your SAS programs, embedded in web apps and elsewhere

Customised Message for incorrect password error

Reply
Regular Contributor
Regular Contributor
Posts: 166

Customised Message for incorrect password error

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
SAS Employee
Posts: 285

Re: Customised Message for incorrect password error

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
Regular Contributor
Regular Contributor
Posts: 166

Re: Customised Message for incorrect password error

Vince,
Thanks for directing in the right path.

Found the following macros to be exactly what i required.

&sysdbmsg / &sysdbrc / &sqlxmsg / &sqlxrc.
Ask a Question
Discussion stats
  • 2 replies
  • 218 views
  • 0 likes
  • 2 in conversation