topic Re: proc sql update error ERROR: Open cursor error: ICommand::Execute failed in SAS Programming

proc sql update error ERROR: Open cursor error: ICommand::Execute failed

havmaage — Mon, 13 May 2019 10:54:01 GMT

When i try to update a table in MSSQL through SAS like this

proc sql;
update sandtab.opret_sqltabel_fra_sas
set Simon = 1
where Simon = 0;
quit;
run;

It errors out with

ERROR: Open cursor error: ICommand::Execute failed. : The requested properties cannot be supported.

its only seems to be updating that fails, following statement works fine on the same table

proc sql;
insert into sandtab.opret_sqltabel_fra_sas ( col1,col2, col3, col4,Simon)
values (99, "Simons kontoform", "N", '2019-05-13 09:48:05.033'dt,11);
quit;
run;

The datatype for column Simon in my SQL table is float.

Re: proc sql update error ERROR: Open cursor error: ICommand::Execute failed

ChrisNZ — Mon, 13 May 2019 22:33:53 GMT

What happens if you run

proc sql;
  connect using SANDTAB;
  execute by SANDTAB (
    update opret_sqltabel_fra_sas
    set Simon = 1
    where Simon = 0
  );
quit;

Re: proc sql update error ERROR: Open cursor error: ICommand::Execute failed

havmaage — Tue, 14 May 2019 06:44:45 GMT

Thanks for your reply,

I dont work unfortunately.

16 proc sql;
17 connect using sandtab;
ERROR: SERVER= option, required for connection, not found.
18 execute by sandtab (
19 update opret_sqltabel_fra_sas
20 set Simon = 1
21 where Simon = 0
22 );

ERROR: The SANDTAB engine cannot be found.
ERROR: A Connection to the sandtab DBMS is not currently supported, or is not installed at your site.
23 quit;

Re: proc sql update error ERROR: Open cursor error: ICommand::Execute failed

ChrisNZ — Tue, 14 May 2019 06:47:02 GMT

You seem to not have declared your library.

Re: proc sql update error ERROR: Open cursor error: ICommand::Execute failed

havmaage — Tue, 14 May 2019 06:56:30 GMT

Actually ít just got to works this moment, haven't

assigned my libname through the server and not directly

like this

libname Sandtab slibref=Sandtab server=saspi;

And then it worked ok.

Thanks for your input.

Re: proc sql update error ERROR: Open cursor error: ICommand::Execute failed

ChrisNZ — Tue, 14 May 2019 07:01:02 GMT

That's a remote libnane. You never mentioned you were using a server. Glad it works anyway.

Re: proc sql update error ERROR: Open cursor error: ICommand::Execute failed

havmaage — Tue, 14 May 2019 07:34:07 GMT

Sorry about that, i am a not that familiar with the SAS Environment but my learning curve is
steep. Have good day