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.
Calling all data scientists and open-source enthusiasts! Want to solve real problems that impact your company or the world? Register to hack by August 31st!
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.