Hi Everyone,   I was wondering, whether there exist any benchmark values regarding upload performance of a MATable-File to MS SQL DAtabase? Here is, what I do: I am only refreshing the metadata counts (i.e. MaTables-File) of four nodes:   What CI does in the background ist initializing a Stored Process Session and among other things executing a macro called "MAUPLOAD".  This macrio, in turn, uploads the locally stored MAtable.sas7bdat-file of the MATables-Libary "MATables.THAAEVZZSKRHHRUZT{SASusername}"to the database.   In my case, we are talking of a file that has only one column, but roughly 6.4 million rows.   Even though I am already pimping the sql-query by setting READ- and WRITEBUFFER to 32767 it still takes about 3 minutes: Shouldn't this be faster? We are using the ODBC Driver  17 for SQL Server, which apparently is not supporting Bulkload     , because every time I am trying to Add BULKLOAD = YES as a option within the porperties of the business context,     what CI in the background does, is running a STP and executing a macro called "MAVALUPD". There the error happens:     "BCP=/BULKLOAD= option not supported by this datasource"     Any help would be very much appreciated.   Thx, FK ... View more

Hi Everyone,   Since a couple of days, the SASCustIntelCore6.5 log (22 MB) is not being dumped into a seperate file every night, but instead keeps on growing ever since April 29th. I do not recall having changed any parameters in any config.xml regarding logging. Can somebody tell me, how to get to the state again, that the SASCustIntelCore6.5 log ist being "flushed" every night in the sense, that there is a file being created like the ones that are shown in the attached list? Cheers, FK   ... View more

  Hello,   when running this code:   %MACRO test(bla=); options minoperator mindelimiter=','; %PUT %lowcase(&bla); %PUT Evaluation value = %eval(%CMPRES(%lowcase(&bla)) in year,month); options nominoperator mindelimiter=%STR(' '); %mend; %test(bla=year); I am expecting to get the value "1" in case bla equals "year" or "month";     This is unfortunately not the case. What am I missing?   My goal is to validate the macro parameter values which are set by the user....   Cheers, FK ... View more