SAS log with snowflake details

[samanvi]

HI All,

Need your help. We are connecting to  Snowflake from SAS ( Linux) and we are exporting the log to .txt file in log we are getting a lot of data 

like below 

Snowflake_3:Prepared on connection 0.

But we see the above for every record insertion. 

Could you help how to restrict this kind of messages in log.

Thanks & Regards   

[ballardw]

It may help to show your current connection code so we we can see the options you have used.

[samanvi]

 This is the connection 

[SASKiwi]

Can you post a portion of your SAS log including your source code and some of the notes please?

Does adding this option to your LIBNAME statement help: UPDATE_MULT_ROWS=YES

[samanvi]

This even helped me Thank you

[Quentin · Accepted solution]

If you set:

options sastrace=off ;

do the messages go away?  I think that is what the sastrace option is for.  

https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/acreldb/n0732u1mr57ycrn1urf24gzo38sc.htm