PROC FEDSQL delete with where statement

ElisabettaC — Wed, 20 Jan 2021 09:02:56 GMT

Hi,

is it possible to run a delete with where statement in PROC FEDSQL?

I try this code but it doesn't work:

cas mysess sessopts=(caslib=public);

libname libcas cas caslib=public;

proc fedsql sessref=mysess;
delete from public.tab1
where id_operazionale=3679532;
quit;

This is the log:

1 %studio_hide_wrapper;

82 proc fedsql sessref=mysess;

83 delete from public.tab1

84 where id_operazionale=3679532;

ERROR: Unsupported SQL statement.

ERROR: Azione interrotta a causa di errori.

ERROR: The FedSQL action was not successful.

NOTE: PROC FEDSQL has set option NOEXEC and will continue to prepare statements.

85 quit;

NOTE: PROCEDURE FEDSQL ha utilizzato (tempo totale di elaborazione):

real time 0.00 seconds

cpu time 0.01 seconds

88 %studio_hide_wrapper;

100

Thanks

ElisabettaC

Re: PROC FEDSQL delete with where statement

BrunoMueller — Wed, 20 Jan 2021 09:12:20 GMT

The following FedSQL statements are supported in CAS:

Please adjust the doc to the version you are using: