The LIBNAME Statement for Relational Databases

LOGDB= LIBNAME Option

Redirects to an alternate database-specific table that FastExport creates or MultiLoad uses.

Default value:	default Teradata database for the libref
Valid in:	DATA and PROC steps, wherever you use FastExport or MultiLoad
DBMS support:	Teradata

Syntax
Syntax Description
Details
Examples

Syntax

LOGDB=<database-name>

Syntax Description

database-name: the name of the Teradata database.

Details

Teradata FastExport utility: The FastExport restart capability is not yet supported. When you use this option with FastExport, FastExport creates restart log tables in an alternate database. You must have the necessary permissions to create tables in the specified database, and FastExport creates only restart tables in that database.

Teradata MultiLoad utility: To specify this option, you must first specify MULTILOAD=YES. When you use this option with the Teradata MultiLoad utility, MultiLoad redirects the restart table, the work table, and the required error tables to an alternate database.

Examples

In this example, PROC PRINT calls the Teradata FastExport utility, if it is installed. FastExport creates restart log tables in the ALTDB database.

libname mydblib teradata user=testuser pw=testpass logdb=altdb;
proc print data=mydblib.mytable(dbsliceparm=all);
run;

In this next example, MultiLoad creates the restart table, work table, and error tables in the alternate database that LOGDB= specifies.

/* Create work tables in zoom database, where I have create & drop privileges. */
   libname x teradata user=prboni pw=xxxxx logdb=zoom;

   data x.testload(multiload=YES);
     do i=1 to 100;
       output;
     end;
   run;

Top of Page