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.
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
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.
Ready to level-up your skills? Choose your own adventure.