topic Re: Raise DB event in SAS Procedures

Raise DB event

LAtwood — Mon, 12 Jan 2015 16:56:40 GMT

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.

FriedEgg — Mon, 12 Jan 2015 18:14:40 GMT

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

LAtwood — Mon, 12 Jan 2015 18:45:32 GMT

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;