I am creating a small stp web app.
I created some PK in a small table. The thing is, when an insert happens the STP will fail if there is a integrity constraint violation. Is there some PROC SQL OPTION or something that when the violation happens I can take this 'error return code' and send a message instead of failing?
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.