cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
aclaraujo
‎05-23-2019
  • 6 Posts
  • 0 Likes Given
  • 0 Solutions
  • 1 Likes Received

Re: Oracle commit for two or more sql statements

by Fluorite | Level 6 in SAS Procedures
‎04-11-2018 09:47 AM
‎04-11-2018 09:47 AM
Hi SASKiwi,  Thanks for response!   But, the problem is source table is a sas dataset.  ... View more

Re: Oracle commit for two or more sql statements

by Fluorite | Level 6 in SAS Procedures
‎04-11-2018 08:42 AM
‎04-11-2018 08:42 AM
Hi, LinusH   Thanks for your attention!   I have a linked_people (id_people1, id_people2) table and a history_people (id_people, operation_date) table. Everytime when insert a row in people_linked table, have be inserted two rows in history_people table. This operation need be atomic. ... View more

Oracle commit for two or more sql statements

by Fluorite | Level 6 in SAS Procedures
‎04-10-2018 08:03 AM
1 Like
‎04-10-2018 08:03 AM
1 Like
Hi everyone,   How to performer a begin/commit/rollback operation for two or more steps in proc sql?   For example:     proc sql; connect to oracle as ora(...); **begin transaction insert into ora.a; insert into ora.b; delete from ora.c; **commit transaction for success or **rollback transaction for fail quit;   Thanks, ... ... View more

Re: How can I get the event data generated by raiseevent.

by Fluorite | Level 6 in SAS Data Management
‎04-04-2018 02:10 PM
‎04-04-2018 02:10 PM
Hi, Audrey I did an example job that illustrates the problem. ... View more

Re: How can I get the event data generated by raiseevent.

by Fluorite | Level 6 in SAS Data Management
‎04-04-2018 07:42 AM
‎04-04-2018 07:42 AM
Thanks for your response.   I cant map my variable using Source Bind because, the variables don´t exists in Event Listen´s output variable list.    they just apearence in run time, when a event is throwed   Thanks, ... View more

How can I get the event data generated by raiseevent.

by Fluorite | Level 6 in SAS Data Management
‎04-03-2018 02:35 PM
‎04-03-2018 02:35 PM
Hi, How can I get the event data generated by raiseevent. I'm launching the event from a expression node with the following keys: raiseevent ("STATUS_DECADAS", "NM_DECADA", "1980") I put an event listen in the job and I linked it to an expression, but I can not read the value "NM_DECADA" posted on raiseevent. Any idea how I can access? Tanks,   ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎05-23-2019 06:59 PM
Likes from
View All
Quick links