I have a relatively simple ODBC connection from R to our SPDS server. I can pull data out from the server - thanks for the prior input. I now have users that want to write data back to the server and I am getting an SPDS_ERROR - writing to the server works but it is very slow. I don't know if the returned error is associate with the speed or if that is another issue.
If anyone can shed some light on what the error means and if there might be a SPDS configuration option to adjust/account for the selection error.
I have attached the program that I am using - note I have reduced the size of the R data frame to a small number of records and fields. It is the sqlSave() RODBC call that returns the error.
This has gone off to technical support. The upgrade from 5.3x to 5.4 fixed one of the ODBC issues with client applications crashing after several queries, but this issue still exists. Tech support is looking at this and I will post the follow-up.
The SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment.
Learn how to install the SAS Viya CLI and a few commands you may find useful in this video by SAS’ Darrell Barton.
Find more tutorials on the SAS Users YouTube channel.