Specifies the database for TPT API restart, work, and error tables.
| Valid in: | DATA and PROC steps, wherever you use TPT FastExport or TPT MultiLoad |
|---|---|
| Category: | Data Set Control |
| Default: | default Teradata database for the libref |
| Data source: | Teradata |
| Tip: | You can use LOGDB= with TPT options. |
| See: | FASTEXPORT= LIBNAME option, MULTILOAD= data set option, TPT= LIBNAME option, TPT= data set option, Using MultiLoad |
Table of Contents
specifies the name of the Teradata database.
TPT FastExport utility: Restart capability for TPT FastExport is not yet supported. When you use this option with TPT FastExport, TPT FastExport creates restart log tables in an alternate database. You must have the necessary permissions to create tables in the specified database, and TPT FastExport creates only restart tables in that database.
TPT MultiLoad utility : To specify this option, you must also set MULTILOAD=YES. When you use this option with the TPT MultiLoad utility, TPT MultiLoad redirects the restart table, the work table, and the required error tables to an alternate database. You must have the necessary permissions to create tables in the specified database.
In this example, PROC PRINT calls the TPT FastExport utility. TPT FastExport creates restart log tables in the ALTDB database.
libname mydblib teradata user=myusr1 pw=mypwd1 logdb=altdb;
proc print data=mydblib.mytable;
run;In this next example, TPT MultiLoad creates the restart table, work table, and error tables in the alternate database that LOGDB= specifies.
/* Create work tables in altdb2 database */
libname x teradata user=myusr1 pw=xxxxx logdb=altdb2;
data x.testload(multiload=YES);
do i=1 to 100;
output;
end;
run;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=myusr1 pw=mypwd1 logdb=audata00_work;
data tera.testdata(MULTILOAD=YES TPT_WORK_TABLE=work);
i=1;output; i=2;output;
run;