Help using Base SAS procedures

Raise DB event

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 83
Accepted Solution

Raise DB event

Is it possible to raise a dbevent in SAS?

Normally the code would be something like this in Ingres:

raise dbevent test

and it would trigger the processing of data within Ingres.

Any help with this would be appreciated.


Accepted Solutions
Solution
‎01-12-2015 01:45 PM
Frequent Contributor
Posts: 83

Re: Raise DB event


Using the documentation provided by FriedEgg, the following works

proc sql;

connect to odbc (dsn=*****82);

execute (raise dbevent test) by odbc;

disconnect from odbc;

quit;

View solution in original post


All Replies
Trusted Advisor
Posts: 1,301

Re: Raise DB event

Yes, you need to use the SQL Pass-Through facility.

Assuming you have SAS/ACCESS for CA-OpenIngres you can reference the following documentation: https://ciser.cornell.edu/sasdoc/saspdf/accoping/c01.pdf

Solution
‎01-12-2015 01:45 PM
Frequent Contributor
Posts: 83

Re: Raise DB event


Using the documentation provided by FriedEgg, the following works

proc sql;

connect to odbc (dsn=*****82);

execute (raise dbevent test) by odbc;

disconnect from odbc;

quit;

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 234 views
  • 3 likes
  • 2 in conversation