PROC FEDSQL delete with where statement

[ElisabettaC]

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

86

87

88 %studio_hide_wrapper;

99

100

Thanks

ElisabettaC

[BrunoMueller · Accepted solution]

Check the doc here https://go.documentation.sas.com/?cdcId=pgmsascdc&cdcVersion=v_007&docsetId=casfedsql&docsetTarget=p...

Supported Statements

The following FedSQL statements are supported in CAS:

• CREATE TABLE, with the AS query expression
• DROP TABLE
• SELECT

To delete rows in a CAS table use the table.deleteRows CAS action, see here https://go.documentation.sas.com/?cdcId=pgmsascdc&cdcVersion=v_007&docsetId=caspg&docsetTarget=cas-t...

Please adjust the doc to the version you are using: