How to change ML_LOG option while loading data from SAS to Teradata library

Reply
Contributor
Posts: 34

How to change ML_LOG option while loading data from SAS to Teradata library

I am uploading some data using Multiload= option in SAS to upload the data to Teradata library.

But receiving the error ..that it cannot create ML_Log tables in SAS installation directory..

Is there a way to change the ML_LOG location so that insufficient permission can be removed..??

Contributor
Posts: 34

Re: How to change ML_LOG option while loading data from SAS to Teradata library

Please find the code as below:

prov append data=work.Test

base=Tera.final (Multiload=yes ML_LOG=err1);

run;

Error: insufficient authorization to access the /sas93conf/Lev1/......./BL_1234.dat

can anybody help in removing the above error..??

Tera is Teradata library...

i am trying to upload work dataset test to Teradata table final...

pleae help in resolving the above error..Please help

Trusted Advisor
Posts: 3,214

Re: How to change ML_LOG option while loading data from SAS to Teradata library

Ask you platform admin to correct to current directory setting.

SAS made a failure with that.  50345 - Changing the current working directory for the SAS® Workspace Server

There are several approaches with Teradata not the same as you are used to common DBMS systems.

With loading data TD can create error notification files for dropped failed records and proceed continuing with all following. A classic DBMS would return an error and stop, not TD.

This is part of thinking in big-data processing. Better missing some records and having all others than having nothing.

(cannot find that refrence  as quickly)

ref:

If the work table or error table names are not specified, Teradata MultiLoad creates them using the target table or view names with a three-character prefix of WT_, ET_, or UV_, as in:

• WT_tname1 for the tname2 work tables

• ET_tname1 for the tname3 error tables

• UT_tname1 for the tname4 error tables

SAS/ACCESS(R) 9.4 for Relational Databases: Reference, Fifth Edition (perfromance)

Your ML_log is just a naming convention not a location.  Better to switch to a location supporting sufficient storage.

SAS/ACCESS(R) 9.4 for Relational Databases: Reference, Fifth Edition (DATAfile)

---->-- ja karman --<-----
Ask a Question
Discussion stats
  • 2 replies
  • 191 views
  • 0 likes
  • 2 in conversation