Hi
The "insertbuff=" parameter is no longer working for Sqlserver. (Since the latest update on sas Grid)
the Libname statement works fine. but when it tries executing the proc append , it gives "Error: The connection to the server has been lost." Error.
i have about 10 table contain about 300K to 400K records each. so without the insert buffer it take a Loooong time.
has insertbuff been replaced with any other option ? Since Bulkload does not work on SAS Grid what other option do I have ?
libname mydblib sqlsvr datasrc=xxx user=xxx password=xxx schema=xxx DIRECT_EXE=delete DBCOMMIT=1000 ReadBuff= 10000 ;
proc append base=mydblib.Smijo_Class data=sashelp.class;
Run;
libname mydblib clear;
I suggest you work with SAS Tech Support on this one. INSERTBUFF shouldn't cause dropped database connections.
To help someone that knows more on this topic than I do you might want to mention which release of SQL Server you are connecting to.
Thank you for replying. Here are the details of the Sqlserver.
SAS Grid Version : 9.04.01M6P110718
SYSHOSTINFOLONG Linux LIN X64
Sqlserver version :
I suggest you work with SAS Tech Support on this one. INSERTBUFF shouldn't cause dropped database connections.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.