BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
smijoss1
Quartz | Level 8

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;

 

1 ACCEPTED SOLUTION

Accepted Solutions
SASKiwi
PROC Star

I suggest you work with SAS Tech Support on this one. INSERTBUFF shouldn't cause dropped database connections.

View solution in original post

3 REPLIES 3
ballardw
Super User

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.

smijoss1
Quartz | Level 8

Thank you for replying. Here are the details of the Sqlserver. 

SAS Grid  Version : 9.04.01M6P110718
SYSHOSTINFOLONG Linux LIN X64

 

 

Sqlserver version : 

smijoss1_0-1595006682338.png

 

SASKiwi
PROC Star

I suggest you work with SAS Tech Support on this one. INSERTBUFF shouldn't cause dropped database connections.

SAS Innovate 2025: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 3 replies
  • 699 views
  • 0 likes
  • 3 in conversation