LOGDB= LIBNAME Option

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

Valid in:	DATA and PROC steps, wherever you use FastExport or MultiLoad
Default:	default Teradata database for the libref
Data source:	Teradata
Tip:	You can also use LOGDB= with TPT options.
See:	FASTEXPORT= LIBNAME option, MULTILOAD= data set option, TPT= LIBNAME option, TPT= data set option, Using MultiLoad

Syntax

Details

Examples

Example 1: Create Restart Log Tables

Example 2: Create Restart, Work, and Error Tables

Example 3: Create the Work Table in a Different Database

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

Example 1: Create Restart Log Tables

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;

Example 2: Create Restart, Work, and Error Tables

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;

Example 3: Create the Work Table in a Different Database

Using MultiLoad with the TPT API, this example provides a different name for the work table and redirects the table to the AUDATA00_work database.

   libname tera teradata user=testuser pw=testpw logdb=audata00_work;
   data tera.testdata(MULTILOAD=YES TPT_WORK_TABLE=work);
   i=1;output; i=2;output;
   run;