Setting default logdir for bulkoad option forrelational database

[OGA]

Hi

When user use the bulkload or bulkunload option, they do not set the logdir option which results in nzlogs being saved in the server C:\. I need to set a default directory for these nzlog files so that even though users do not specify a location, it is saved in their work directory H:\temp. 

For example, if they specified the logdir, the code would be similar to this:

proc sql;
create table net_air.flights98
       (bulkload=YES bl_options="logdir 'H:\'")
        as select * from sasflt.flt98;
quit;

So I need a way of setting the logdir by default in a config file I guess

More details abour the bulkload and bulkunload options below:

https://documentation.sas.com/?docsetId=acreldb&docsetTarget=n119slgt394onmn12yd81pyytvin.htm&docset...

Thanks in advance

[JosvanderVelden]

BL_OPTIONS as used here is a data set option. As far as I know it is not possible to set such an option in the sas configuration file.

[OGA]

Hi

Thanks for your reply.

Is there any other way to achive what I intend? ie, prevent users from creating logs in the C:\ directory

Thanks

[ChrisNZ]

Writing to C:\ is not a good default setting.

Asking for a global way to alter this sounds like a good idea. Make a proposal in the SASware ballot.

On the other hand, C:\ is often kept off-limit to users by the OS settings. You could check that.

Failing this, a regular deletion of the files can probably be scheduled.